Is SEO for affiliate sites dead?

Super Aff asks the question:

http://superaff.com/archives/2006/09/05/
is-seo-for-affiliate-product-sites-dead/

The article has a useful overview of what types of affiliate sites are still managing to rank in the search engines.