I know it's a chain and not "hip", but the Holiday Inn Express in Astoria is right on the river and has great views of the bridge too.  Have had a couple of nice experiences there when visiting the city.