Basically, I climbed down from the Throat of the World feeling all triumphant and proud. Reached High Hrothgar, not a soul in sight. Ok, that's a bit odd, maybe they're all at Whiterun. That's where I was last at, after all. I travel to Whiterun and these are the first things I hear:
"Ugh, you smell like a wet dog." (So I've been sweating, I've only been fighting for several hours straight.)
"Hands to yourself, sneak-thief!" (I'm a hero, not a thief?)
"You let a captive dragon go, I'll never understand." (Uh, I rode that dragon. You know, to save Tamriel. No? Ok.)
Pretty much everyone I talked to at Whiterun/Dragonsreach didn't give a [censored] that I just saved the world, or even wondered what happened after I rode off on a freaking dragon's back. It was like nothing had happened.
I tried talking to the Blades, they just gave me crap about not killing Paarthurnax. (After much deliberation, I climbed the mountain determined to kill him just for the sake of not missing out on Blades quests. When he started talking about redemption I just couldn't do it! Amazing how Bethesda makes you feel for characters, even ones that aren't humanoid.)
I'm thinking, as was pointed out multiple times throughout the main quest, the population at large didn't know about Alduin's return. It makes sense that they wouldn't mention it. However, I didn't even get so much as a pat on the back from the people involved! I would have at least accepted a sword, armor, or some character's dialog saying "thanks for saving us." Is it because I didn't kill Paarthurnax? What happened with the temporary peace treaty now that its basis has been taken care of?
Finished the main quest feeling triumph, turned into dejection. I'm starting to feel like the main quest is all in the character's head... "I killed Alduin. No, really, guys! Why won't you listen?!"
I got more ending satisfaction out of the Thieve's Guild today...

I didn't get to take in any interesting details like that, barely got to see what the place looked like.