It’s a pet peeve of mine, I hate stealth sections. Waiting around just isn’t fun and most stealth sections are just that.
However, that was years ago. I haven’t encountered one in a long time since I mostly stopped playing AAA games - by now these games are an amalgamation of so many worse design decisions, I almost miss the time stealth sections were my biggest issue.
I don’t play actual shooter myself, however, both Pokemon Snap games fit your description - might be worth a shot.