As bad as it is, I really doubt it would put New York or Hong Kong underwater. They would build seawalls well before that happened.
It's the other long term effects on ocean life and weather conditions that concern me more.