Name a touhou game (main series or fan made) that looked really good but when you actually played it, it was either just really bad or painfully dull/tedious/repetitive.
For me Touhou Pocket Wars (any version). While it really seemed fun at first (great artwork and music, after pointless card battle number 5000300204 to level up enough characters to do the story events, I really just wanted to kill someone.
It is one of the few games where I just said "screw it! I can't take it anymore!!!!"

Subarashii Sekai Superbly Seductive
The Wolf-Boy & The Girl in The Red Hood Sweetly Feral
Rory Mercury Cosplay Godly & Gothic
One Piece: Burning Blood Trailers Fiery Hot
Ero-Manga Sensei Anime Announced