Hi There,
I have not tried Drupal myself, but have been told it is very good! I am thinking of learning to use Drupal to actually see for myself how good/bad it really is.
I personally use Joomla as my main web 2.0 content manager. It has everything from a shopping cart to ad managers to subscription components! Which is all fantastic for affiliate websites.
There is a learning curve involved with it, so do some research before you dig in.
If you are new to content managers, and you are looking to build the site yourself, I believe the best bet is Word Press. Lots of themes available and quite a few plugins!
My suggestion is to have a plan of what you want your site to be in the future. I.e. do you want to sell your own products down the track, or do you want to add a forum? I think taking all these factors into consideration important so you choose a content manager that is extensible, and will meet your future needs!
I know people who have built a basic website using a small system, or some expensive system they found, and realised 6 months down the track that they cannot add on a certain component to expand their site further!
This can cause a bit waste of your time and resources, as they have to search for another system that will meet their needs!
One good place to look is
Home - OpenSourceCMS. They have demos of a lot of good content managers.
I am not saying there is anything wrong with Drupal or Word Press, I am just saying its good to take a look around before you settle for one system!
Just my 2 cents worth!
Cheers