Warrior with magic is a pretty common concept in fiction to emulate, it looks cool, and spells can be overpowered compared to the martial systems, so getting some can make your character far more effective.
This, I mean, Elric was a swordsman and a wizard. The Grey Mouser dabbled in magic. Corwin of Amber knew magic, and despite being labeled a Sorcerer, his son Merlin could hold his own in fights. Belgarion carries around a giant two-handed sword on top of being the most powerful magic user in his setting. Rand Al-Thor says hi. Sparhawk is a Church Knight but is more of a Fighter/Warlock than a Paladin (but ironically, not a Hexblade).
We also have Paladins and Rangers and the original Elf class (not to mention the Bard from 2e on) to remind us that the seeds of the hero who uses whichever weapon is better at the moment (be it sword or spell) just makes sense when you live in a dangerous fantasy world.
Then there's those players who want a true synergy between sword and spell, using one to enhance the other, but the D&D magic system isn't really built for such- you tend to have to make some serious sacrifices to be able to overcome the action economy that generally lets you use magic
or swing weapons around, but not both.
So aspiring to this archetype has little to do with aspirations of twinkhood, IMO. It's just something a player might feel is logical to do, and they may be emulating a lot of fictional characters who mix magic and sorcery- how about them "Space Wizards" from a galaxy far, far away?
And in fact, if you're really trying to game the system, you're usually better off sticking to one or the other, since D&D has rarely rewarded a split focus- you'd think being a versatile character is the way to go, but you tend to be mediocre at a lot of things instead of being stellar at one or two things.