I've always liked Chonqing's location. I feel like they should do a better job with the waterfront though. It's a bit messy and doesn't seem so people friendly. Maybe more shopping malls, more greenery, some overlooking platforms, etc, etc...
Then again, I've never seen the waterfront upclose in pictures or real life.