Gaming

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

Fable

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.

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

Witch spring r lets you become op af easily .

Severed steel is insane and 2 bucks on gog.

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.

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

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.

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.

Hmm. What about Nier: Automata?

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.

Stellar Blade ?

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.

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

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

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

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

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.

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.

No Mass Effect? Too AAA?

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.

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

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