I'm not as big into anime as I used to be... but I got reaally hooked on Haruhi Suzumiya when it first came out.
I was also part of the legion of people who were incredibly disappointed with the second season's Endless Eight arc.
However, it does fit nicely with the movie, The Disappearance of Haruhi Suzumiya!
What an aaaamazing film!!! It was beautifully animated the whole way through.
The storyline gets incredibly deep and very involving. And I loved the writing; being adapted from a novel, it sort of makes sense. But Kyon is especially a fantastic narrator to take the viewer through the series, fulfilling a sort of bystander role. But his clever...um, thoughts, I guess (when its just him in his head) are surprisingly a highlight of the show to me - he makes incredibly insightful remarks haha.
Basically it starts off with a Christmas celebration that Kyon is not at all excited for, but wakes up the next day and everything is "Normal". As in, aliens, espers, and time-travellers don't exist and Haruhi doesn't even attend the school. Spoilers below...
Esentially, you learn that Yuki is sort of fed up with the amount of slack she takes, and wanted a sort of break. She offers Kyon a normal life, and a decision to keep it, or get back the crazy life where the SOS Brigade exists
You sort of get the notion that the author probably digs the harem games; all he girls seem to crush on Kyon a little bit. Goddamn Japanese making the most unlikeable putz being chased by (usually) gorgeous voluptuous anime chicks.