What are some examples of affiliate sites that sell consumer products and are appealing to the eye?
One example I would mention is FlamingoWorld.com, an established coupon site, as well as ClubMom.com, a rewards site.
In the case of both of them, in my opinion, they are very clean, intuitive sites. I am, by no means, a usability expert, but I think they are easy to use.
I think that’s ultimately the most important thing. I’m not really sure what you are looking for aesthetically, but these are affiliate sites that a great many consumers are using to shop.