Still really want some names so I can check them out.

Since honestly, I can't think of any besides Baldur's Gate, and those are extremely severly light on day/night differences. Witcher I also had somewhat like it, but it wasn't working well, and they canned it entirely for it's subpar sequel.
And that sums up all 3 RPG's I know it happens in the last... ehm... 14 years.
So yeah, I really wish to know which one I missed during all that time.