I've just fitted a K-Tec stealth. It's pretty quiet but still louder than standard. Seems louder, when you start the car and when going up hills on motorways and dual carriageways but otherwise only slightly louder. It is fine when cruising on the motorway. I've heard the Yozza sport one is quieter still.
Search on youtube, people have put videos of the different exhausts for comparison.