So with the 1200 would there just be compatibility issues with graphic oriented programs such as games, or would that also affect my choices for sound software?
There will be problems with games and productivity software. Many games can be patched using WHDLoad but you have to own the original copy.
What sound software you are going to run? Newer software run just fine (from 1995 and newer) but if you prefer using sound editors from soundtracker era (late 80s and early 90s) then you have issues.
Nevertheless I still recommend getting Amiga 1200. If you run into compatibility issues you can try to find replacement software or run downgrader utilities.