I felt that the SVT had a quiet exhaust and the RT cat sounded good with the stock exhaust. It made the popping louder on decelleration. It was loud enough for me and gave a decent tone. Since then I've added a Borla exhuast and it sounds 'Ricey' to me, but it made the sound deeper. I think it made the exhuast slightly louder, but my mom says it is quieter. I'm not too sure, perhaps it did get quieter, but I'd really like to know how when the Borla has 1 less muffler.
I really can't comment on the power gains because I did another mod around the same time IIRC... maybe a tune... I can't remember. I noticed more power, but I also had a bit done to my car before the cat.
The O2 sensors should be fine because you are keeping a catalyst.
If you want a little more power and a slightly different and louder sound, get the cat... maybe hold out and see if one goes up for sale soon. I've seen some cats for sale every now and then.