I am in the process of upgrading (actually doing a clean install) of Snow Leopard on my iMac. There are still a number of programs that are less than fully compatible. I would be inclined to advise most users to wait a couple of weeks so those applications can catch up.
Not much visible difference in Snow Leopard, but things do seem a little snappier.