Well, starting July, which coincidentally was about when the last official teaser video for second season was released (the infamous live security cam), a series of fan-made character song videos began to appear in various video sites, all carrying common title, theme, and tune.
Title - The One I Love Doesn't Notice Me, or Too Many Compete for the One I Love
Theme - The singer laments Kyon's lack of attention, despite her/his(?!) best efforts to appease him
Tune - borrowed from I Can't Defeat the Air Man, a riot in itself. Video game music turned parody about an unkillable boss, with hyper lyrical train, mounting frustrations, and the last straw - all of which must be ported into a successful Haruhi fan vid.
http://www.youtube.com/watch?v=KLbFctG3tw0 (karaoke)
http://www.youtube.com/watch?v=26hIA0CT2tk Alright, enuf setup, let's get down to it.
Yuki - (the original?)
http://www.youtube.com/watch?v=WsLkchAAo2I (key line: beautiful breasts are nothing but wasteful deployment of fatty cells)
The Trilogy Yuki vs Taniguchi vs Asakura
http://www.youtube.com/watch?v=ExLvr0elWqs http://www.youtube.com/watch?v=jAeMfjtYwCg http://www.youtube.com/watch?v=mmp9wMVitQk Mikuru
http://www.youtube.com/watch?v=7HKCKk-v2Ho (Shy) Haruhi
http://www.youtube.com/watch?v=QOpI6k4jPe8 Asakura - (a fan fav, playing on the jilted love turned psycho)
http://www.youtube.com/watch?v=0rcbJoJGfx4 http://www.youtube.com/watch?v=ur-sSqKB1Cg http://www.youtube.com/watch?v=JfnKRugVQoA (Getting Yaoi)
Koizumi
http://www.youtube.com/watch?v=7McTpWmCgxE Kunikida
http://www.youtube.com/watch?v=VGPnS_hx0JY Brother-con
http://www.youtube.com/watch?v=lfz6BAqtdMo even Tsuruya (reg. required)
http://www.nicovideo.jp/watch/sm683190 Notably missing is Kyon, and of course the Overseas Editions.
edit: bored...
