I'm sure there'll be others on here with much more informed advice, but I'm using VMware Fusion and found it very easy to install and use. I am running it on the very latest iMac 2.8GHz Intel Core 2 Duo Extreme with 2GB of RAM and Leopard 10.5.2, so I don't know if you might encounter performance issues with lesser machines.
I have to run MS Access, SQL Server and Visual Studio and have had no problems to date. It's great being able to able to swap between the PC and Mac windows at a click, plus the PC can be 'suspended' rather than shut down and so starts up again in seconds - far faster than my PCs do, even taking into account the 20 seconds or so the Mac takes to start up.
Hey everyone, I'm looking to get Windows on my Macbook Pro. I was wondering what you think would be the best way of doing this, such as getting Leopard with Boot Camp, VMWare Fusion, etc. Thanks.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic