I totally agree that air intakes sound pretty nice, but I think it's pointless to buy them just because of the sound. I only trust the intakes with proven HP and Tq gains that are measured on DYNO. The most capable intake that I've seen was giving +12HP which is pretty good. Pretty good article on topic:
My Car is Brand New, Why Should I Change My Air Intake System?