There really are some miserable people about! It's pretty obvious that there's been overwhelming support for an all night tube for many years now, and all the research suggests that it will have a positive impact on London's economy.
If you don't want to use it, then don't! I personally like the option and feel it is a safer (and much) faster alternative than taking a night bus. I remember trying to take a night bus from Oxford Street last year - it took so long to get off the street due to the traffic and this was in the middle of the night!