Well of course if you usually have 3-4 people in a car and/or lot of slopes I4 probably is not going to be powerful enough. Sure. 90% of people use flat highways and streets, maybe single passanger max, often drive alone to work and back. So for the majority I4 is fine ASSUMING no extra weight.
For those occasional trips when you load entire family, a lot of baggage, etc. V6 will be superior. But how often do you do that?
Perception of performance is all over the place. A lot of people have expectations of "instant" pass, approximately something like 10 seconds to pass; well give or take. For that sort of performance no amount of power in a car/SUV is enough, so 200+ hp V6 is perceived to be better.
Now you could rev up I4 and do a 15-20 sec pass, which is usually Ok with some anticipation. Frankly even on my Kawu motorcycle I have to downshift and rev up to get peak HP for a quick pass.
Conversly someone who grew up in Europe on a 1.3L Peugot will be convinced that a 2L or 2.4L Mazda I4 is a speed monster and could not even imagine anything more. Hey I moved from a Yugo to a 1.5L Civic and thought it is real fast

So it is a matter of perception. At some point you have to draw a line and say this is enough. Some people draw the line at 2.xL I4, many others keep going to 200+ hp V6. What I find odd is that many people just don't want to draw any lines. Why not 5L V8. Oh, I do REALLY need a pickup for .... (fill in a made up excuse) If they had money they'd just keep going to say Jaguar V10 or whatever they have.
I prefer to get a vehicle that will perform well for 80% of my driving and don't worry about extreme cases. I can always rent a V6 for long trips or whatever.
As for performance/speed, I just hop on the Kawi bike. Much easier that way.
P.S.: Don't get me started on the spark plugs. All my I4s are fantastic, pleasure to change them. However, Kawi Ninja has fuel tank on top of air filter on top of cylinders. Yep, gotta remove fuel tank and air filter box just to change plugs


Well at least they are light and easy to remove.