Like any utility, there is always a risk when used.
In so far as to Norton's specifically, most of the horror stories all stem from pre-Mac OS X versions in which the product installs extensions that are running all the time and cause conflicts with other apps.
Besides that, I use Norton's...