This article was what set me to musing over this.
Stuff I loved, that was too short lived/hamstrung from the outset/killed before its time...
Crimson Skies
Firefly
Veronica Mars
Pushing Daisies
Human Target
Vanguard
Sid Meier's Gettysburg!
Then, there's the stuff that should have broken into a new format/media years ago, but just doesn't seem to get any steam...
Crimson Skies
Invincible
Then there are entire genres that have just died out on me...
Tactical Turn-based Strategy
Flight/Space Sims that struck a good balance between simulation and accessibility
These days, I'm almost afraid to like quirky, interesting projects for fear of cursing them to destruction. Stuff like Air, Leverage, White Collar, Frozen Synapse...
Every once in a while, something I'd given up hope on shows hope of getting some karmic justice, so I guess things like HBO's aGoT and the upcoming Deus Ex may be enough to keep me going on...