While gateway cities will always remain attractive, residents and investment shift towards Sun Belt markets