What made the show great other than the characters was the premise, for me at least. I wanted to see what would happen when Haruhi finds out what she really is and what subconscious powers she possesses. I wanted to see a conclusion and Kyon finally taming her. It just never got to that last level, that peeking behind the curtain stadium. Just a million indirect hints through the SOS brigade's other members.