There are few if any good value up and coming places which tick most of the boxes nowadays in the US et al. 20 years ago yes, not now. So there are usually big compromises. Either the place will be expensive or it will be fundamentally lacking in something. Ultimately depends what you are...