The ending wasn't unexpected, but it was beautifully done. Overall the show was a good watch during the summer. I wouldn't place it among my favorites, but I liked it.
Now, with this over and no more new episodes of Haruhi, the only anime I'm watching are Fullmetal Alchemist: Brotherhood (of which I am SO looking forward to the next few episodes; the last few have been awesome) and Umineko no Naku Koro ni (which is getting boring; I might drop it soon). Can't wait for more Darker than BLACK next month!
EDIT: http://www.animenewsnetwork.com/news/2009-09-17/detective-conan-akira-kamiya-to-leave-kogoro-mouri-role Ehhhhhhh?! D: