I have actually found day night cycles become irritating to me in current games. It is constantly cycling and I just keep exploring having to deal with low visibility periodically.
If a day night system should exist, it should be based on user decision to explore at night versus day. Beyond that it is just a cosmetic. Also with the inclusion in BG3 of darkness lowering chance to hit, night cycles make combat harder for non-nightvision characters, so that is another conscious decision by Larian to not have cycling day/night impacting combat.
We have to think how it impacts the game as a whole and not just "it would be fun if".
I felt the same about the system even in og BG. The only games who ever did anything interesting with day/night circle were the elder scrolls games, specifically the option to become a vampire in these games