As a frequent pax my view would be that it's broadly specific to aircraft size.
Long-haul, on widebody, I never saw a single passenger get ill. I'm sure it happens but I can't remember it.
On narrow-aisle aircraft, in bad weather, for sure it still happens. I don't believe in-flight turbulence would usually provoke it; however landing approaches in bad weather certainly do.
I speak as a suffererer myself; generally my balance is poor and I like to see the horizon, especially during banking manouevres.
But still touch wood, I never actually got ill since I was a kid. Closest shaves? In the stack outside Dublin in an ERJ145, during a winter storm
. Crosswind final approach into Newquay on a dash-8
compounded by looking after my son, who WAS being sick.