That's an amazing view in Hong Kong! Unfortunately, there is nothing similar in NYC.
The area around the cruise terminal is fairly desolate. The city is in the midst of developing and revitalizing the area along the Hudson River, but this has not reached the cruise terminal area yet... and based on my most recent visit about a month ago, I believe it will still be a while.
The closest major hotel is where Cruise Fanatic stayed, the Holiday Inn-Midtown. It is located on 57th Street between 9th and 10th Avenues. (Streets run east-west, Avenues run north-south.) I don't know much about the Skyline Hotel other than it also appears to be conveniently located. But, an unobstructed view of the piers from either location is unlikely.
One place I can think of for dinner with a view is the aptly named "The View Restaurant" atop the Marriott Marquis near Times Square. It offers a 360-degree view of the city from about 45 stories up. The dining room used to slowly revolve so that everyone would eventually be able to see the entire city, but I do not know if that is still the case. Reservations are required for dinner. There is also a bar there, but I haven't been.
If I think of anything else, I'll post again.