Of those three Cheers easily takes it.
I've always thought MASH had one of the worst theme songs I've ever heard.
As for the Hawaii 5-0 intro, it sounds extremely generic for a 70s theme.
Yup, Cheers wins it. The lyrics of the song make me wish I drank on a daily basis and went to a bar that everybody knows my name and is always glad I came.