You'll have to commute across the Hudson, but New Jersey's Hoboken PATH train station ... you won't find better vistas of the NYC skyline; just make sure to ask the front desk for a room ...