Totally agree -- it's my only real complaint with the car, but it's kind of a big one. I would say it gets harder to overlook the longer I have the car to the point where I now will take my wife's ID.4 when I drive after work. I prefer the Tesla in every way over the ID.4 otherwise but sometimes I think the ride quality of the Y is eating at my soul. I'd really consider getting a used EV of another company if the Tesla wasn't a 1000 times easier to road trip in my area.
For me it's not so much the comfort of the suspension but it's so bloody loud over a lot of my local roads. It really sounds like a low grade thunderstorm. I've driven these same roads with a 10-15 year old Jetta, a Mazda CX-5, and an almost 15 year old Sebring my whole life and I never noticed the quality of the roads before I got the Model Y. Oh well, first world problems for sure it's just my first new car in 20 years it's kind of grating (the wife got the last two since she drove the kiddos to school).
I test drove the S a couple of times and I do like it, I just can't justify spending another 40K to get the ride quality of the ID.4. At least it's better in the spring/summer as I drive with the windows down and everything's great then.