My fave was the nobel sword or something from the Oracle Zelda games which could shoot a really satisfying beam of light to damage enemies from further away
Reminded me of mini Hyper Beams from Pokemon except you didnt have to recover or charge
Also love the triple Lyonel bow from BOTW. That thing fucking slappz
The Groovitron from Ratchet and Clank. It interacts with every enemy and boss, is pretty powerful under the right conditions, and is the right kind of silly.
Oh man, Ratchet and Clank had some awesome weapons. I remember the first time using the mini-nuke after upgrading it from one of the early game weapons putting a huge smile on my face