Well... That moment of the sleeping bear was a staged event. It would be awesome if it happened as a part of the game outside of that particular situation.
ORLY? Animals sleep? That's pretty awesome...if it is really true. And this isn't too spoilerish for me I guess. It's more like "Huh...that's neat. I'll have to check that out ingame."
Actually, animals don't sleep in the game. The sleeping bear is part of a tutorial on stealth. In the wild, I haven't seen (and do not expect to see) any sleeping animal NPCs.
I hope it wasn't scripted, but if not it' not that big of a deal. Sleeping wildlife is pretty hard to find IRL, so it would be weird encountering it frequently in Skyrim.