I can go either way for me. Sometimes I feel refreshed, others I feel horrible. It all depends on the day I had really, I think. For example, if my day involved heavy exercise, after a sleep I feel awful and stiff, while after a sleep with an illness, I still feel crap in the morning.
However, on other days, a good nights sleep is fantastic, and I wake up feeling great.
Still, I don't agree with the whole "9 hours sleep a night" thing. For me, a good nights sleep is 5-6 hours, and that's it. Any more than that, and I wake up feeling grumpy.