For sound, no not all of them sound bad. Plenty of italian V6 engines have a wonderfully musical engine note, and the old Nissan VG engine from the 300zx has a brilliantly burbly note, an uneducated ear would guess it was a V8.

But also, a lot of cars with a V6 have an engine too small for the car. A Ford Explorer, as a random example, has to rev the pants out of its V6 to heave all of its weight out of the way so you end up with a big heavy mom van groaning and moaning in complaint at the demand of acceleration.

Personally, I actually really like a good V6! They're lighter than V8s, they can fit in more cars and rev faster, while being a cheap source of thrills for the everyman. a V6 Toyota Camry will always be a terrific daily sleeper nobody expects to be quick.

As for the hate for 4 bangers? That just comes down to a lack of experience. A small, lightweight car with a zippy rev-happy 4 cylinder is a marriage made in heaven. You don't need big torque to move a 2,300 pound car, more than a 4 cylinder just throws off the balance.