Sekiro truly did that to me, especially the boss rush where I took a chug of water before getting started and got into the flow zone for the next hour.
Doom Eternal and especially its challenge arenas are immediately what came to mind for me!
While id soft screwed Mick Gordon on the OST, they did so much right in the gunplay and movement mechanics in that game. Rotating through the power trinity and bhopping around an arena whilst gibbing demons is something I just don’t tire of.
Dark Tide (Warhammer 40K). The combat just flows so well, and the relentless hordes of enemies lay on the kind of pressure that forces you to use every tool in your character's arsenal to its maximum potential.
Anything that can get my adrenaline pumping, which generally only happens with multiplayer games when I am facing a human opponent. Dark Souls is a great example for me, here, because the single player gives me that rush for a while but eventually I'm able to breeze through every boss and enemy in the game with minimal effort, so going into invasions and getting sweaty against a host and his 2 OP phantoms is the only way to get that rush again, because, generally speaking, other players can think so no two opponents are really ever the same.
I actually kinda wonder now what the flow state even feels like to others who suggest things like strategy games or puzzle games. To me, it's like that fucking hyper focus the protag has in the movie Wanted. Crazy Lazer focus on whatever action is going on, and it's just like... Automatic. No thoughts. Just actions. So I'm really curious how it might manifest in something slower paced like Civilization and what not. Or even how some folks can enter that state via meditation. That sounds awesome and I wish I could trigger it with something else.
Apex Legends. Its a difficult game to master, but every once in a while I get "in the zone" and pull moves/plays that impress myself. It's not often, but feels nice when it happens. I still enjoy it even though I "suck" most of the time. I basically play it as a survival game >90% of the time.
There are a lot of cues that happen in the game and you just kind of respond to that. I mostly play roaming supports so my brain is wired to go straight to mid after recall then look around the map to see where my presence is useful. The most obvious cues are the junglers.
Anyway, it's kind of like flash cards. When you memorize things with flash cards, at some point you don't really think anymore. There's a default answer to every situation. But sometimes you get it wrong though. If you get it wrong too often, then those are bad habits.
Roguelikes. Binding of Isaac is one of my top played games with something like 500 hours in the game. I put it down a year or two and picked it back up like nothing. Just dodging and weaving and min maxing like i never stopped. Even new games that have a similar feel, I just tend to lock in and end up getting really far in my first run.
The Last of Us does too, but I tend to zone out and take my time sneaking around or observing stuff. So I don't play it unless I know I have a lot of time to waste.
Sound Shapes did it for me too, but I haven't played in awhile.
Monster Hunter World once I got down the controls/equipment well enough that I didn't have to think about them. But once I dropped it, I didn't go back because I don't have time to relearn.
Halo Reach would take my time for hundreds of hours back in the day. It's a unfortunate/fortunate that the Master Chief Collection doesn't include multi-team in matchmaking.
Xcom was a good one too during missions. I have some great war stories from that game. My first encounter with chryssalids was straight out of a horror movie. Quickly went FUBAR and barely got one soldier out alive.
For me, it's probably Richard Burns Rallye.
Some times just everything seems to fall into place as you flow through a stage and the weight of the car transfers just right from one corner to the next.
Also the boss fights especially in the souls series...