It depends on the site. I click on the penny-arcade ads all the time.

I'll click on google ads sometimes when I'm looking to buy something but that doesn't usually result in a sale.