Outside of the two episodes written by Darin Morgan, Millennium
was pretty bleak. Of course, it was mostly a crime series, but there were some fantasy elements.
Your point is well taken, though; these programs are outliers, not the norm.
I haven't seen it, but isn't The Invaders