Even if you have a custom-coded site and know code and have a great template doesn't mean you'll have a single visitor nor click-throughs. Esp. after Google penalizes sites for displaying Amazon content. It's really about getting qualified visitors no matter the site.
I have several sites running Associate-o-matic and they do generate sales - enough to pay for my cds and dvds