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...
