I never saw myself as a hero either. If I were to make a character today and tabletop, it'd probably look like Chris Pratt. I don't try to invest my real life self into the game and I think that defeats the purpose to a small degree.
When it comes to my gaming in RPG settings, it's been everything from dabbling like a young idiot in D&D back in 1983 to playing video games hack and slashing in Diablo or using mods in Skyrim to block, slash and run with unlimited stamina.
Who the fuck cares.
I just play to have fun, pick a character for sake of coolness or attributes (I always take Argonian in ES games due to their natural bonuses and swim ability to make exploring easier), but I just play to romp around, loot, and at some point finish the game and never play it again. And some games I dont even bother finishing, so technically the hero didnt win. Who cares. It's off to the next game.
I remember the first time playing D&D, I made a Dwarf fighter. My brother filled out the template for me. Back then the game box came with character creation paper. I dont know if they still do that. I just took that character because I wanted to fight and Dwarves had a big axe. I'm not sitting here daydreaming about life in grade school and how a Dwarf is going to make me a better person in life. We all dropped playing it, since we preferred video and computer games or Risk. It was too much work reading through the guidebooks and having someone being DM anyway. Seemed more like a chore.
I wonder for people who take gaming seriously for self esteem if they purposely play them at easier difficulties so it makes them feel more powerful. Or they purposely play on hard, so if they win it makes them feel even more powerful.