Self insert power fantasy recommendations?

While it's not indie: Cyberpunk 2077?

You can make your character as pretty as you please (though, no "sex appeal" -slider like in Saint's Row :D). Also, no 3rd person camera, so you'd only see your character in inventory screen. Otherwise there's bit of boobies to be seen - and massive amounts if you so choose with modding.

Difficultywise it'll cater to very casual approach, but the game does the "bethesda-thing" where you will end up as destroyer of worlds regardless of difficulty.

edit: btw, you might want to specify your platform? No modding for cyberpunk on consoles as of yet, I just assumed PC here.

These come to mind where you can kill enemies, be a girl, and are or are similar to an rpg:

Middle Earth: Shadow of War: main character is a guy but in one of the expansions you can play the story as Galadriel. Killing monsters and game mechanics are peak

Skyrim Mods: ik you mentioned Skyrim, but The Wheels of Lull, The Tools of Kagrenac, and The Forgotten City are game sized mods in of themselves and are very good

Elder Scrolls III Morrowind and IV Oblivion: both as good as Skyrim, but in different ways. Go in with an open mind and you will be amazed

Star Wars KOTOR I & II: my favorite games of all time, very much games where you can choose how your character acts and who they become. Great story too, as a fan of star wars or not

If you like Prey 2017, and you want to kill things like an absolute monster, and you want to play as a girl, Dishonored 2 is a good fit for all of those things. It’s not indie, and I’m not sure you can see boobs, but it’s a great game by any measure (though it’s not well optimized on PC). It’s not an RPG and it lacks the large skill tree of Prey, but it is an action-forward stealth immersive sim with cool eldritch super powers.

If you want to play Hades as a girl, you can play Hades II :D

Last Epoch: Fun ARPG with a couple different female characters available. The buildcraft complexity strikes a sweet spot between Path of Exile and Diablo 4. You can definitely turn your brain off and kill enemies by the truckload.

Fallout 4: Along the lines of Skyrim, just swap fantasy with post-apocalyptic sci-fi. You can play as a girl, and see plenty of tiddies depending on mods (shoutout to the "A Storywealth" collection on Nexusmods).

Fallout 3 and New Vegas: see above, just older.

Wayfinder: fun RPG game with set characters, but a few are girls. Combat was fun IMO. This one started as a live service game, but after backlash and their publisher dropping them, the devs rebuilt the game as a pay-to-play game with an end.

Bayonetta: kill tons of baddies with over-the-top combat as a sexy witch.

Dynasty Warriors & other "musou" games: lumping these together, but girls to play and TONS of enemies to kill

Granblue Fantasy: Relink: plenty of girls to play as, and fun combat. Honestly, the biggest drawback to this one IMO is not enough content after you finish the campaign.

Saints Row 2, 3, 4: definitely self-indulgent trash, definitely boobs, still fun

Hmm. What about Nier: Automata?

No Mass Effect? Too AAA?

Since New Vegas isn't on your list it has to be my top recommendation. Of all games I've ever played, New Vegas is the most reactive to and acknowledging of the insane and unbelievable things the player does. The actions the player takes have permanent effects in the game, and everyone affected will know that the player is responsible for whatever happened and say so. You personally control the fate of every community in the Mojave. In other games, you are powerful on behalf of the story, but in New Vegas you personally are all the power in the entire game.

In my headcanon, DOOM 2016’s player character was a genderless force of anger incarnate. No boobs, but power fantasy for sure.

In that vein, if you wanted indie games, you could look for any recent boomer shooter like Viscerafest (yes girl), Ion Fury (yes girl), or Selaco (yes girl). Searching for the “boomer shooter” tag on Steam seems to yield a lot of female protagonist power fantasy games

The only boomer shooter I’ve played lately is Prodeus which doesn’t have a female protagonist but can definitely exemplify the strengths of the boomer shooter subgenre

Hades IIs character is a girl, and it’s very fun.

I'm not sure if Rollerdrome might be your thing, but I enjoyed it. You play as a girl competing in a roller-skating death arena. It's a bit like Tony hawk games, but combat plays a huge role, it's very satisfying and it's very well integrated with the rollerskating. I really enjoyed the first ten or so scenarios, but I'm not so good at score based games so I never finished it.

Elderborn is an indie first person "metal AF slasher." I guess it could be considered souls like. but you can be a lady barbarian thwacking skeletons with a hammer. Well theres a bunch of weapons but hammer rules. Id say its a tough game but not all that hard.

Theres a kick mechanic where you can boot an enemy over a ledge. Landing one of those is just about the most satisfying thing for me.

How important is being an RPG in this case? (as I note only a couple of your examples are in that genre)

The below suggestions are not RPGs, but I think fit your request.

It's a survival game, but Conan Exiles ticks a lot of those boxes once you get a bit geared (which doesn't take super long), and it can be played single player. Just have to be okay with some janky experiences.

I will also note that you are a girl in Hades 2.

Sifu is another one you might enjoy, though bosses certainly are a challenge.

Bayonetta is probably the most pure example of a horde-fighting action game with a sexy female witch protagonist. Lollipop Chainsaw is there too, for more of an airhead protagonist. Darksiders 3 could fit the bill as well.

There are lots of new Skyrim mods since the last time you played it. Even if that was only last week.

Stellar Blade ?

Code Vein is a Soulslike with an excellent animé-style character creator.

Dragons dogma 1 and 2 fit the bill I think. 2 more so than the first.

Fable

BG3 is pretty good for that to be honest - good character customization, there's a learning curve to be sure so its not a power fantasy until you get past that.

It's not an RPG but how about Lollipop Chainsaw?

It has hordes of enemies you can slaughter (which provides a certain kind of relaxation, to be fair) as a pretty girl who possibly looks like you maybe, and you can see boobs.

I never actually played the game (although I'm interested in playing it) but it was the first thing that popped into my mind.

I'd recommend Kingdoms of Amalur if you've never played it. It has neat lore, and the combat is fairly satisfying imo. My main complaint is that combat gets kinda easy when you start approaching the level cap, even on max difficulty, but I still go back to the game every now and then.

I'm having a lot of fun playing mount and blade : bannerlord. The combat is satisfying and the game has quite a lot of depth. It can be a bit overwhelming but I think it's worth the 2h attempt. For the power fantasy part : get good at polearms and riding, get yourself a glaive, optionally download the mod that allows you to hit several enemies with a single swing and mow down lines of infantry with each charge.

Also, blizzard bad but Diablo is fun

It depends on your definition of "pretty" but in Dungeon Crawl Stone Soup you get to slaughter countless hordes of critters to dragons. Go for a brain off Minotaur Berserker with an axe and shield and get killing! Go here if you need more character ideas: https://tavern.dcss.io/t/a-compendium-of-the-most-iconic-builds-for-each-species/1057

Witch spring r lets you become op af easily .

Severed steel is insane and 2 bucks on gog.

It's.... probably not what you're looking for but I'll throw Warframe into the ring just in case. It's technically an MMO I think? And not exactly a traditional RPG progression either. There are definitely boobs, but your character won't look like you

But it checks the slaughtering hordes of enemy box. Power Fantasy is turned on day one I think

Idk what you look like to narrow down the recommendations. 🤷🏻‍♂️

I will say that despite all the negative shit I've heard about Forspoken, I think the combat and traversal systems are super fun and the stupid bracelet is vastly more annoying than the protagonist. The game is literally "girl boss power fantasy" too.