It's always the slow, tedious stealth with brain-dead, forgetful, myopic enemies, magic tall grass and repeated patrol routes. Never mind that crouching doesn't actually make you quiet. If they wanted it to be fun, they'd let you slowly run at or by the unaware enemy, as the old stealth games like MGS and probably Thief used to. After Splinter Cell and a hundred other games standardized crouching like an old man, Hideo Kojima did the same.
I know stealth is usually an option (because no one makes true stealth games anymore), but the games are usually balanced in such a way that it's easier (and more boring) to take the slow approach. You can bet if Resident Evil 1/2 came out for the first time in 2020, you'd spend 50 percent of the combat with your knees bent, moving almost as slowly as the zombies.
I can't even remember the last time stealth excited me in a game.