I like playing Pyro in capture maps especially when I'm defending. They can be very effective close range but really suffer in large areas.
Although... I played in a server today where half the server were pyro's (about half and half on each team). It was carnage and a lot of fun :)