Technically that harpoon is a pretty impressive weapon. You throw that at someone in real life and you're far more likely to kill them than you would be if you had a number of the other weapons.
I went with Rinoa's weapon because I never quite liked it, but really I find all weapons in FFVIII to be okay once you get past the fact that this is a Final Fantasy game.