I suppose it depends on the system, the sound will differ on certain brands, and the more boxes you take out the louder it will be, just keep an eye on the legalities of this when it comes to MOTing your car.
With regards to looks, I went for a single pipe on each side, it's a bit less overkill and in your face. Imo quads are better suited to performance petrol cars.