Magic typically hits from wherever, with some long range restraints.

If I'm having to go room to room, I'll take some form of club, tomahawk, or shotgun. If it's a forest setting or something a little more spread out, a nice bow or assault rifle, perhaps some grenades. For distance, the obvious choice is a crow's nest with something from the American military M series, or something like a Dragunov or a PSG.

(This is all from gaming experience. I don't pretend to be some weapons expert. )

It depends on the scenario. I'm happy as long as the enemies drop.