Hard to find anything new under 2500sqft. It seems all builders are going for these days are 5/4 3500sqft mcmansions. I’d gladly scoop up something newer and smaller in a better location. 4/2.5 2000sqft sounds perfect ( assuming newer with an open layout 😉 ). All of the older homes in UTC/clairemont area seem to need so much work. From what I can see most are littered with DIY re-models and repairs.
Even though I see the absurdity in buying a massive newer home, there seem to be plenty of buyers lining up for these. So why not play the game, enjoy the property and then sell it to the next millennial with oversized dreams? :).