i've Daily'd straight pipes with no cats on two of my cars, but that was back when i did everything for performance and didn't really care about comfort. It really depends on how dedicated you are.
Not all 4 cyl are created equal. some 4 cyl sound better than others regardless of exhaust set-up. There are too many contributing factors to say just look at any 'ol 4 cyl. for example, there is 6 bends in the fswerks exhaust system, all six of those bends alter the sound. My civic only had 2 bends before the over axle, if i were to run a straight over the axle it would be quieter than "LCR dump."
If I ever get the funds I would choose the RH and stealth exhaust ...maybe one day