You remember Oblivion from back in the day. It's worse than Morrowind in a lot of ways but the real-time day-night cycle and the NPC movement was engrossing. Quests where you have to go find people, and they can be in tons of locations are so interesting. Sometimes you have to figure out when someone goes home, Idk. Also characters would occasionally exhibit quirky behaviours. Every subsequent Bethesda game diminished this aspect hugely, it's one of the things I hate about Skyrim most.
Another series where the games never hit an early height of world sim again is Pokemon. Gold & Silver introduced day and night cycles that would have NPCs appear or disappear, wild pokemon encounters change, radio stations come on or off, certain items show up. For a system with 32kb of ram, it slapped. Other games have the cycle system but it's easily the most pronounced in G/S/C.
The "life sim"/'you are a loser farmer' genre as pioneered by Harvest Moon (and now happily overtaken by Stardew Valley and its ilk) have always had this kind of system, and I do like those a lot but if a game's not "about" its scheduling, it seems like they're more likely not to have it nowadays. STALKER: Shadow of Chernobyl and its sequels had day/night at least, Metro did not... So if you know of any recent games that have really cool scheduling or realtime or day/night mechanics, hit me up. Also don't say Cybertruck'd 2077, game is boring and stupid :)
Makes me think of Majora's mask. Instead of a single night/day cycle, a 72 hour repeating cycle where certain quests where you had to talk to one person at a specific time range on a specific day to causing someone to be at a specific place at another time, and so on. Even OOT had a basic day/night cycle, but MM took that idea much further. Far from a recent game though.
Even the kinda bad 3DS remake is almost 10 years old
Ay that was the game that brought this on, I was watching Rosencreutz' video on Majora's Mask. It's very cute, I dig it.