There are many factors that go into how good or bad clear film protection will look. The brand and quality of the film is extremely important. Just like cheap tint that turns purple, a cheap film will discolor and looks bad. How the film is maintained is also important. A car that doesn't have its exterior maintained properly will have bad looking film. The paint looks like crap too, but the film is different so stands out a bit more.
I definitely understand why people aren't fans, but I'm a big proponent. I have it on all my cars and will continue to have it on my cars.
For reference, here's my Legacy from a few months ago. 8 1/2 years old and the clear film still looks good, but that's because I maintain it.