To find out what won't run in 10.7, go to the Apple Menu, go to About this Mac, go to More Info, go to Software in the left column, click on Applications, then click on Kind to sort by kind. PowerPC apps won't run (I have Classic apps in my list, too, since I've been migrating since the early days of OS X). 10.8, due to be released in late July, will even be less compatible with older software, and may give some Intel and Universal 32-bit applications problems - so upgrading to a new Mac with 10.7 will be more predictable and more forgiving than waiting for one with 10.8 (and if you buy now, you'll get a free upgrade to Mountain Lion).
The current Mac Pro's can be downgraded to 10.6 without hassles, but you need an install disk that will work (a 10.6.3 universal installer that may be available on eBay or other places, Apple no longer sells them). We tried putting 10.6 on a new Mac mini and couldn't get it to work completely - so, anything but a new Mac Pro probably won't work reliably or completely with 10.6.
Tony