A lot of people are against it because it scientifically has been proven (in other car forums) to rob power due to heat. And if people get the long version (that goes down behind the bumper) they are also opening themselves up to hydrolocking. IMO, and many agree, you're better off with the RAM air duct + stock filter box with nice clean filter + z-tube. A CAI is a race car part that people put on cars that aren't anywhere near race car level. Race cars need filters like that for obvious reasons. Not enough air can be supplied via the standard means. But they also have heat wrapping, etc. to combat the heat. They don't just put a CAI in and call it a day.
Think of it this way...you have a pipe in a lake that is moving ice cold water. However, surrounding that pipe, is super hot water (it's the apocalypse afterall or something). What do you think happens to the water inside the pipe? It doesn't get as hot, but it certainly gets warmer. That's what you're doing with a CAI...unless you do other things like using heat wrapping (to keep the engine bay heat out), etc. etc.
Because the CAI is made of aluminum (almost always) it transfers heat easily...where as the OEM stuff is made of a plastic that tends to keep the heat out.
It DOES make the car sound good and does look good...but unless you have SERIOUS engine work done, I personally don't show off my engine anyway so it's kind of a moot point.
If 'looks' and sound is what you're after, then CAI is for you. If you want a little bit of sound and a more efficient air delivery system, the other option is better. It's all good though, we all mod how we want

.