GM, I don't know about folklore and legend, but I know that I get some of my best work done between 2 a.m. and 4 a.m. I frequently feel the most inspired during those hours.
When I was courting my wife via the internet (she was in the Philippines and I was in Arizona), more than once I woke up at about 3 a.m. with the startling and strong feeling that I needed to get online to talk to my darling Juvy. When booted up and the connection made, Juvy had just logged on in a nearby internet cafe looking for me. Coincidence (meaning accidental coincidence), or cause-and-effect coincidence? I like to think it was the latter -- an inspired, spiritual connection. Proving such doesn't matter to me. It just feels good and right.
I've also had some of my best ideas, waking up at 3 a.m. or close to it, having gone to bed the night before with the question on my mind. The solution arrived and I woke up.