Well, when I said I had many games to play I wasn't speaking solely of RPGs. But, off the top of my head, here are some RPGs and and similar games from the last 15 years that had day/night cycles. Although, admittedly, not all of them had full NPC schedules. But gameplay was at least affected in some way by the time of day.
Divine Divinity
Neverwinter Nights
Neverwinter Nights 2
Fallout 3
Fallout new Vegas
Don't Starve
Minecraft
Gothic
Gothic 2
Gothic 3
Temple of Elemental Evil
Deus Ex
Nitpick some of these if you like; all of this is very subjective. Clearly this is a feature which you do not value much. I, on the other hand, value it greatly.
