If nice cars get destroyed in an exciting scene in a good movie, then that's absolutely fine with me. As long as the scene is done right, I've not got a problem with it.

However, what I do dislike seeing is nice cars getting wrecked in AWFUL movies. Transporter 2 is a movie so awful that I can't even put it into words, and it even annoys me to see a ten a penny Crown Victoria get destroyed in a completely worthless movie like that, especially in really absurd scenes with supposedly professional law enforcement officers driving like utter morons.

http://imcdb.org/vehicle_71262-Morris-Minor-1957.html
This classic Morris Minor is blown up in an utter abortion of a movie. How many of these can there be left in the USA and they had to destroy it?

http://imcdb.org/vehicle_130013-Ford-Mustang-1966.html
The movie wasn't awful, but this final scene was not only criminally wasteful, but also immensely stupid. Read my comment on that page for more details.