As for the witcher 3, I don't even remember if it was really a cosmetic. Time probably didn't matter in general there. What did it matter if you could change your time freely at any time.
I dont think so ...
There was many monsters you could meet only in night time, some quests required specific hour, there was potions and stuff for dealing with low light etc.