I've tried ClickBank in wp posts as a contextual thing but the selection of products isn't varied enough to make it do-able for me.
CB is make money and ebooks - for the other 90% of the worlds topics I needed some other ads so I had to develop something else.
The problem with having tons of products to offer dynamically is that you have to get approved by a ton of merchants first. The only ways I can think to do this really well is to run the clicks through a service that has 1 aff account with everything and pays from there, or just use ad sense.
Or maybe a plugin that selects the best aff network fit, trys to find a good product then falls back on another option, like adsense.
I will think about it a bit more.