The response is fairly mixed. But overall, most people are saying they enjoy the extra visibility in the AdWords area by having a Google Checkout Badge displayed prominently on their AdWords listings.
There are many pros and cons listed in the forum thread but I wanted to get a poll going myself. If you currently or recently used Google Checkout, will you or have you continued to use it after the fees started kicking in?
Forum discussion at WebmasterWorld.