Hi Lionheart.
I'm a bit of a Mac fanatic myself so would thoroughly reccomend one over a Windows based machine, and i would dearly love a MacBook Pro. If i understand you right you want to get Office for the Mac and some way of running Adobe CS on it...? As i understand it Office 2004 should run OK using the Rosetta - but have you considered using an open source version? Open Office is basically the same as Microsoft Office, but free! The other alternative is to use Bootcamp and install XP on the MacBook too, this way there is the possibility of running all your current Windows software on the new Mac - altho Bootcamp only at the beta stage at the moment.
You might want to check out some Mac forums for more details advice.