Enter the Gungeon was the absolute worst offender. Rare health restores at every level meaning you need to play well even on easy early levels. Hugely important max hp boosts granted only for flawlessly completing each level boss. Items have no indicator for how useful they are unless you get a feel for them or look them up, then have a bunch of hidden synergies which are also unexplained; and even then you have no agency in getting other items to make your crappy loot more viable than permanent garbage. And lastly, a single rare item which doubles the length of a run but vastly increases your chances of long term success.
People love rare OP combos but they kind of suck.
I'd rate Risk of Rain 2, Dead Cells, and Dungeon crawl having the best implementations of this.
I'd put Risk of Rain down as the one of the best generic rogue action games to recommend. The first one is a 2D shooter. The second one is a 3D shooter and is especially good for online co-op. I would recommend starting with the second one.
I think some of this could be solved, or at least mitigated, if there was "meta" progression, like in Dead Cells. That way, even bad runs could result in something worthwhile, rather than a total waste of time.