Looking for the correct link to "The Melancholy of Haruhi Suzumiya", the light novel, I stumbled across many, many light novels that made me bounce of the walls! Especially:

"Yukikaze" by Chohei Kambayashi! Yukikaze, people! It's coming out Jan. 2010.

"Fafner: Dead Aggressor" by Tow Ubukata. I bawled my eyes out watching this anime!

And then there are others like "Trinity Blood" or "Shakugan no Shana". And I also own the first vol. of "Kyoh Kara Maoh!", hehe.

What I really hope to see in English one day is Clamp's "Soryuden" and Shindo Tatsuki's "Four Dragon Island" *crosses fingers*