I put on SP2 a fair few days ago, and it scary that I haven't actually noticed it. Apart from the Security Centre popping up at the very start, its not a great deal different.
None of my programs have stopped working, nor have I noticed any incompatibility problems.
You have a good point that peoples PC's will differ. Mine and Mike's PC must be similar tho - we both have no problems with it