Adobe CS4 runs perfectly on Windows 7, and if you have Adobe CS4 64 bit be happy because you can take advantage of your 64 bit system, so what I want to say is that Adobe CS4 64 bit has an exellent performance in your 64 bit Windows 7.
About Office 2010, don't worry, it will work properly in your system.
Regarding the "other software" you mencioned, keep in mind that Windows XP Mode was designed primarily to help companies to migrate from Windows XP to Windows 7. It is NOT optimized for advanced graphics programs, such as 3D games, nor is suitable for programs with hardware requirements, such as TV tuners.
About 32 bit or 64 bit system, is a topic with an extended discussion, that I recomend you to open a new post to discuss this. I will be pleased to post you back as many others will be.