Are battles more enjoyable with less technology?

Wondering if there is a majority preference to this.

Swords vs guns, fantasy vs sci-fi. I'm specifically thinking about moments where there is a big battle scene.

I know we have to suspend reality, but part of me thinks whenever I see a massive battle/war in a sci-fi setting, why doesn't one side just launch missiles or lasers or use something big. This cheapens things, in my opinion. Not to mention the battles will be over much sooner.

I also think a warrior who has mastered his skills with a sword or melee weapon is more interesting than a sharpshooter or gunslinger.

I know it's mostly personal preference, but just curious what the majority and average person feels.