Metroidvania games can be pretty good for this sometimes. One that really got me was Bloodstained: Ritual of the Night. You have to get an ability to progress at a certain point that is a random drop from an enemy. Any game that relies on RNG for progression is going to make me go running in circles. I love the game, but did not love that part.