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
Tap for spoiler
until you progress through a sufficient quantity of the main story, and even then still not part of your standard gameplay.
But it checks the slaughtering hordes of enemy box. Power Fantasy is turned on day one I think
it definitely still can be, the devs have been putting a lot of work into streamlining and improving the new player experience, so a lot of the overwhelming options are still available but more things are trying to point you forward. All of the main story quests are separated out in your codex now with their unlock requirements, otherwise the advice I have always heard is: explore the star chart and unlock new planets. Which will never let you down if you're feeling lost