Of course you click through if you're intrigued enough. I'm not sure carousels are meant to create intrigue about a product. I'm not really sure what their purpose is. Every carousel I've seen has been probably better off being displayed all at once rather than one at a time. This is the Internet, many people (barring disabled/elderly users, who shouldn't be ignored) are used to consuming a lot of data simultaneously, most don't want it fed through a tiny straw.
I see them as a design fad that are typically asked for because someone's friend/competitor has one, or "ooh, ahh" 'ed at by clients who didn't know animation on web pages was possible.