D2 doesn't focus so much on power fantasy, rather focusing more on skill & team cooperation/coordination with a fair degree of challenge at the end game. there's Anthem, but I wouldn't recommend it at this point ). Likely the closest thing there is to Warframe conceptually ( well.
Definitely doesn't have the same life span that Warframe does IMHO Negatives: Personally, I had a good time with this game, but eventually hit point where there wasn't much else to do except for min-maxing to death. It does has its own 'cartoonish' style, which may not be for everyone. Well known for showering the player in loot while you're mowing down large groups of enemies in a frenzy mayhem.
If you want a power fantasy looter shooter and haven't played this one yet, may want to give it a try. I assume you mean looter shooters, so here's a quick short list based on my own experience ( and assuming you haven't already tried them ):