Yes, you right about V8. They also do tend to have greater displacement than engines with fewer cylinders.

I can't say I value the engine note that much. Certainly not enough to outweigh a difference in efficiency, power, or price. I'd be perfectly happy with something like a Subaru boxer engine.