i dont even want
to know who put Stilleto under useless weapons....
I love using it in multi just for taking down those pesky anti-fighter beams on corvettes and cruisers (but, of course, I use the treb for that too
Morning Star- Excellent single player weapon as well as multi. I use it mainly to shove Shivan bombers off and to shoot their bombs down (if you do it right, you can move larger ships like cruisers too).
Lamprey-Like people said before, use it to drain the guns and afterburners on other ships in muti; useless in SP tho.
Circe- Fully agree with Sesq on this. Use it with the Maxim and you've got a lotta dead Shivans (or anything else with shields for that matter), especially then placed on a Herc II (little energy consumption; good gun placement).
Inferno- I use this in the Bastion mission occasionally, mainly to give the Shivan bombers (especially Nephilim and Seraphim) a little surprise and pain. I use in MP mainly to damage cruisers/corvettes and to damage escort fighters packed in tightly.
As long as we're on the subject....
Prometheus R - Love the Subach-Prom. R combo; Subach depletes shields while the Prom dishes the damage; grows useless after the Prom. S comes into service.
Tempest-Excellent for wasting Fenrises (no kidding?
); more seriously, takes out large turrets (like the Orion's main guns, the Hecate's flak turrets, and the Aeolus's guns) with ease; can fit 400 of them in the Herc II's second back.
Hornet-Good mainly because of the amount carried. Wastes old transports easily (ex. Azrael, Isis, Elysium). Aside from that, nothing really good there. And, like the Prom. R, becomes outdated when the Tornado comes into service.
Pirahna - Overrated. People say its great for surpressing fighters, though it doesn't really work well when i use it; mainly just used to pester enemy fighters and shake 'em up a bit by the shockwave, which lets you get a good aim with Harpoons.
EMP-Awesome for escort missions; scrambles enemy bombers tracking systems and sends them off course.
Those should be all the *pathetic* weapons.