Has anyone seen an online comparison site they really liked and that worked well?
There once was a good book comparison site called acses(?). It was a student project and worked really well. Then it got bought and changed names to evenbetter. Then they got bought and changed names and are now part of evita. Some where it between they screwed it. I really liked it.
Question: Affiliate marketing - what will happen to the little guys trying to make some money out of the web now?
Good question. Guess they won't make it on the product tab. But if on the other hand, Amazon doesn't show up in the regular SERPs (they now often do) there'll be an empty slot. :) You will just have to have good content to get the regular searchers or focus on international buyers. Product search will mostly apply to US customers, I assume.