This is something that all Elder Scrolls games need, at least for some players like myself. Leveled enemies are boring. I've played like 500 hours of Requiem Skyrim and can't play Oblivion without the Obscuro's Overhaul.
Unfortunately I'm really not getting the same spawns that other players are reporting. In the wilderness (tedious travel) I'm getting a lot of animal spawns like Spriggens/Bears/Tigers etc. at both night and day with the occasional bandit/zombie/gargoyle. Night doesn't seem any more dangerous that daytime. Haven't had any super unique spawns like Vampires at all.
Not sure if this is intended or if one of my mods like Warm Ashes is conflicting. I'm now using "Wilderness NPCs" mod in place of Warm Ashes, so I'll see what this does.
Seferoth: I'm amused by your stories/explanations of your experience with this mod and it's spawns!

For me it's fun to hear about other player's experiences in games, particularly when they are unique. Well, I guess that's also why there are video "let's plays" online. Just not the same as something in writing.