There's a great scene of the hero waking up in Douglas Adams' "Dirk Gently's Holistic Detective Agency", I can't remember how it goes & all my books are currently on the other side of the world, but I highly recommend it, if you have to do waking up.
It's not at the start of the book, altho it is the first time the hero is introduced. But by that time, we've already been on another planet, had a couple split up, somebody got killed and Odd Things have happened at a formak college dinner in Cambridge. So the reader is already well hooked by this point.
On the whole, I'm with what most of the others said - unless the waking up is integral to your plot (hangover, startlingly beautiful stranger found next to hero in bed, house fire) I'd skip it.