I would guess "dorky", "nerdy" are more mildly self-deprecating than pejorative nowadays. But this could change wildly from one area to another.
Also, there's Football Manager, which takes the 'playing football' game out of the game.
But I do find something attractive about games that keep someone's brain active. Never played factorio though my colleagues wax lyrical about it ad nauseum.
Think I've completed that circle by suggesting to a friend working on accounting SaaS that he look at FM as UX inspiration...
Non nerds and non dorks have hobbies, always had. Having hobbies is quite normal and used to be normal. And frankly, playing computer games was popular among popular young boys for whole generations now.
"Dorky", "nerdy" never really described average gamer. It described small groups of people who had social issues regardless what they did - including sport.
As a kid I said I played Secret of Mana on a weekend (SNES) and for the rest of that school year I was taunted and called "Secret Banana", haha. How far we've come. Or have we.
These kinds of games are the most uniquely intellectual outside of puzzle games, programming games, and even more difficult strategy games.
We exist. We generally are not motivated to provide proof that we exist, especially because many requests for proof are expected in the form of "SEND NUDES". That was not implied in your comment, but your experience likely consists of this exchange and mine reflects a universe of incredulity and harassment.
If you gain insight from reading this, great. But that's not why I'm replying. Somewhere reading this thread is a girl in high school or a woman in college who's into grand strategy, or programming, or something else that's "uniquely intellectual". She's heard messages all her life that girls and women aren't the kinds of people who do this stuff. I know this because I've been that girl - going back decades to where I would read "I'm pretty sure there are no 12 year old girls using Linux", at age 12, from my dual boot Fedora/Debian machine.
Sis, you matter, even if you're just starting to get into this. If we only look at gaming, I've had thousands of hours across Factorio, Paradox games, Zachtronics games, and study sims (not to mention - gasp - mass market tactics games), but you can't get to hour #1000 without hour #1. Whether you choose to keep a low profile in nerd spaces or you choose to be a Girl Gamer (TM) lightning rod, I'm glad you're here, and I hope you pay more attention to comments like mine than the one above mine.