I'm somewhat torn though not overly. Things I like are the immersion of time passing and actually having to do some personal maintenance like eating and sleeping, though I'm aware some people hate that kind of stuff. But seeing days and nights passing is significant for me, especially games where the night time can have significant effects: the recently-played Dragon's Dogma means night-time is often very dark indeed so if your lantern runs out it kinda sucks as you have the choice of blundering about in the dark or fast-travelling back to one of a few distant locations and trekking back to where you were the next morning. Oblivion was mixed in that the vendors would shut up shop and AI routines would change, though by default the nights were too light but a proper darkness mod made them more interesting. Currently playing hack-and-slash favourite Sacred 2 where nights mean at least a significant change in atmosphere.
But then there's the "so should I get on with it?" element which is the gnarly bit. I dislike even passing dialogue hassling me to do so but if that's actually implemented as a timed quest I am not a fan; especially the "stealth timed quest" that some games are fond of where you can find out the hard way it needed to be done by a certain time otherwise with no warning it auto-fails on you. I would rather live without that!