If I opt in for the content network, will the reports tell me which sites are bringing in traffic so I can target them for CPM or even do a deal direct for those that produce?
Yes, you'll see where your impressions/clicks/etc are taking place. http://adwords.blogspot.com/2007/06/introducing-placement-performance.html