From what I understand, there is no real 'ultimate' weapon in this game - it does pretty clearly detail which weapon gives the best STR/MAG bonuses, and what other bonuses you get out of other weapons, though.