I think I've only used them in ff5, if ever. Maybe one in ff2j. (aside from using them as cheap healing in ff7 because I couldn't be bothered)
Four of my already pitifully few item spots were elixirs, before I realized the beauty of aspil (although when your mp gets absorbed they're usefu)