@dannydan, I have 50+ years experience with motion sickness. I agree with previous posts that ride stiffness isn’t really the source of the problem. THE number one thing is for the passenger to be able to adequately see out the window and not be focusing on something within the car. I don’t know how old your kids are, but I do know how low the model 3 back seats are. I would guess that is the biggest problem with the model 3.
Tangent - model X isn’t great for back seat passengers with motion sickness issues. Can’t see over seats in front limiting passenger’s ability to look forward and see out.
I was intrigued by your desire to get a CR-V after owning a Tesla. I was in need of an ICE after owning a Tesla, and was quite sure the CR-V would be it (previously had a Honda Odyssey for 12 years). 2 minutes into the CR-V test drive it was off the list. Like you, I am not an aggressive driver, but I found the CR-V so overwhelmingly underwhelming in it’s power. I want to merge into highway traffic without effort and don’t think I would have been happy with the CR-V. As a side, we ended up with a Volvo XC40 instead, and it’s met our ICE needs. I wouldn’t recommend it for a family if 4, tho. Too small.
I do not own a model Y but am a huge fan of them. Have test driven one and had some as loaners at service appointments. Love the glass roof. It was much quieter than our model 3. The higher elevation is always nice. Great hatchback and lots of room - more than the CR-V, I think? (I’ve not looked at specs.)