Aeris is the only character whose most powerful weapon is not her ultimate weapon.

As for weapons the official guide left out, besides the Behemoth Horn, the only ones I can think of off the top of my head are Cid's Flayer and Bullet's Pile Banger.