If you want to get a G5 it will run all the latest software provided you has OS 10.5.2 installed. Its not as fast as the latest machines but still does a great job. To run PC programs at PC speeds all you need is to use BOOTCAMP which works seemlessly from within the Mac OS
http://www.apple.com/macosx/features/bootcamp.html.