Which geographic area will give most bang for buck for commercial RE? NYC, upstate NY or CT?

NYC maybe unaffordable altogether, lol. We’re thinking 400k to 500k downpayment can help with $2 million range affordability?

Any advice would be very much appreciated. Thanks