@DblOSmith MYP is definitely lower...I think MYP vs MYLR height difference is larger than M3P vs M3LR ever was. (Tesla no longer lists the M3P as having "lowered suspension," but they still do for MYP.)
I never tested MYP because it seemed clear the MYP wouldn't address my issues with that MYLR demo car (ride and wind noise).
I don't think lowering springs would do much good in terms of ride or handling for either Model Y or Model 3, it feels like the dampers are the weak link. They lose all control of the car's weight when pushed really hard on twisty back roads, and even on smooth sweeping ramps the car never feels 100% settled - which I think is the damper's job, no matter how soft or stiff the springs are. Plus the Model 3 feels challenged for suspension travel and ground clearance, lowering can only make that worse. (Y is better in that regard, probably could lower some while still having decent travel and clearance.)
I was fine with the stock M3P ride quality, especially after moving to 18s. And like I said, it was fun and put a smile on my face right away, that's why I was very happy to buy one! But the Model 3 brought out the old driving connoisseur in me. Years ago I used to do track days, chase snowstorms for fun, tear up twisty mountain roads, etc. Model 3 handling is okay at a decent pace but fell apart when pushed really hard, and I had just experienced much higher quality suspensions in other EV test drives - Polestar 2 Performance (P2P) with Öhlins DFV, and Mach-E GT PE with Magneride.
So based on that P2P I got the Redwood Motorsports Öhlins DFV "Performance Sport" kit for my car, along with MPP FLCA bearings (highly recommended!) and compression rod inserts (just because). Handling is transformed, and it rides perfectly fine, better than stock when the dampers aren't cranked up super stiff. ("Performance Sport" has stiffer springs than stock though, if you don't want that the "GT" kit has softer stock-like springs and should still be a major handling upgrade.)
I doubt any suspension kit would give a Model Y the suspension refinement of a Polestar 2 Performance, but my guess is I would be pretty happy with, for example, the Model Y Redwood GT (comfort-focused) coilover kit. However I don't want to buy a family car where I'd
require an aftermarket suspension just to be happy with it. Many Model Y owners are perfectly happy with how their Y drives though, so don't let me talk you out of the Y if you tested one and liked it!
Btw I'm only talking about these mods here because you mentioned maybe lowering the car. I'm not trying to talk you into modding in general, there's real risks and downsides beyond just buying and installing parts. I had some experience and knew what I was getting into.