Well "Who Are You?" asks a question, and in the case of CSI they sometimes have to answer questions like Who was murdered, who was the murderer. So it does kind of work.
But I suspect if ENT had been better scripted, had more rounded characters etc.. that we wouldn't see as many complaints about the theme song. When we are not being suitable enteratined we start to pick apart things about the show, from the major elemts such as characterisation, plot to the more minor elemtns such as theme song/tune.