Pushing Daisies is not a guilty pleasure, it was an excellent show. Damn that writer's strike!
I will also add "Invasion" from FOX, starring William Fichtner. A very good drama/sci-fi, that lasted an entire season. I think 22 episodes.
"Threshold" was another good drama/sci-fi from CBS, starring Carla Gugino, Brent Spiner & Peter Dinklage. Only lasted half a season.
"Journeyman" from NBC starring Kevin McKidd had a neat premise, but very few people were watching.
Would have been great to see "Veronica Mars" last longer than 3 seasons.