There wasn't any threads about the series in Anime & Manga board besides
Haruhi-chan, so this will have to do.
This is about the games though.
[2007.12.27] Suzumiya Haruhi no Yakusoku -The Promise of HS- [PSP] Bandai Namco Games
[2008.01.31] Suzumiya Haruhi no Tomadoi -The Perplexity of HS- [PS2] Banpresto
[2009.01.22] Suzumiya Haruhi no Gekidou -The Excitement of HS- [Wii] Kadokawa Shoten
[2009.03.26] Suzumiya Haruhi no Heiretsu -The Parallel of HS- [Wii] Sega
[2009.05.28] Suzumiya Haruhi no Chokuretsu -The Series of HS- [NDS] Sega
A trailer for Heiretsu on Wii just showed up.You get to interact and react to quick time events with the Wii Remote.
And also unlock stuff like 3D Model Viewer, and other Gallery stuff.
Trailer and screens of the Nintendo DS game.
There's also doujin games made for the series.
1. "Suzumiya Haruhi no Chourantou"
2. "Suzumiya Haruhi no Gekitou"
Screens of the PSP game I took about a year ago.
"Kyon-kun, Pinch! Pinch, Punch, Ponch!"