On both my 10.6.7 installations (iMac 24" Core Duo and MBPro 2006) System Profiler works fine until I ask it to list Applications.
Have repaired permissions, verified and repaired disk, no joy.
I have the crash report if anyone can decipher it.
Problem solved. I did a Get Info on System Profiler and noticed the check box for Open In 32-bit mode was not checked. Since I have not been running my system in 64-bit mode, for kicks, I checked the box and again asked System Profiler to provide me with a list of applications. This time it worked.
Maybe this trick will help you.