I don't think weather and day and night have to be that complex, but I would like to see it in game.

Well, in older RPGs there were events that would make you play at night, or the weather would change. IMO, there's no NEED for a cycle, but it would be nice to have a part in the game when it would become night or the weather would change, something like that. To create rare rain weather that would make some npcs go to cover is cool and simple. The point is that the areas that one goes through in D:OS make one not miss weather cycles, because there was a snowy area, a dark area, a beach area, a windy area, and that was satisfying enough.