For what its worth, I'll add my thoughts as someone who owned LR RWD 3, LR AWD 3, and then debated getting another tesla as well as performance 3 vs non performance Y. Initial thing was that getting ANOTHER model 3 seemed like it'd just be another car and wouldn't feel different. I also have another ICE suv and realized I really like sitting up a bit higher, having space, etc. Now all that said, I don't NEED the space - don't have kids dont haul things often and the 3 always had good space for me.
Now that I"ve had my Y, man I don't know. The Y is everything I thought it would be, but it simply will never "feel" like the sporty nature of the 3. This could be a serious case of always thinking the grass is greener, but if you ask me - my inner car guy longs for that sporty, almost tossable feel of the 3. If you want the more versatile vehicle, get the Y. If you really ENJOY a sporty driving car, IMO you need to get the 3. Not that the Y drives poor, it just isn't low slung feeling like the 3.
I honestly don't regret my decision to get the Y. It was the right choice with all factors considered and I trusted my gut. That said, theres a decent chance I trade my Y for a performance 3... For the vast majority of people, Y is the answer. I'm weird though.