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 :)
I think about Oblivion and it's NPC scheduling far too often. It feels like the missing piece in otherwise amazing games like Deus Ex MD or Pathologic 2.
I remember MGS V had elements of this. Guards would patrol, be relieved at certain times, there was scheduled transports of prisoners and resources. If you knocked out an entire base of guards at night eventually the morning shift would turn up and start waking them up, putting the base on alert.
I did not know that about MGSV, pretty cool.