I love the new look and Cover Flow on Finder; don't much use the Dock as I use QuickSilver so the Stacks stuff doesn't get used.
I've gotta wait for me to buy a TimeCapsule before I can try out TimeMachine which does look cool. Apple are so good at sucking money out of my pocket :). Am gonna have to buy an Apple TV now too.... Wonder how long before they'll support the UK on movie rentals.
So far I still prefer iTerm to Terminal due to it being able to have preconfigured named shells & starting directories (I've often got tons of shells open).
The upgrade was great; I just installed the DVD, kicked off the install and came back later and it was all completed.
So far the only real nit was bash shells lost their prompt, so I had to add this to my .bashrc
export PS1="\w> "Not an amazing upgrade or anything, but I am preferring Leopard.
Update : I've just noticed TextEdit now opens OpenDoc files natively - nice!