I took my husband to the Cannery Pier Hotel this Saturday for his birthday. We had a blast. As others have said, it is situated out on a pier very close to the Astoria bridge and near the shipping channel. The hotel itself is beautifully decorated with many nice touches such as the free bikes, free chauffeur service around town in the vintage Buick, and a wine & munchies "happy hour" every day. The main reason to go however, in my opinion, is for the view of the river. We had a HUGE container ship go right past the window in the late afternoon & also a tug pushing a barge, but there are also lots of other boats to watch even if you don't get lucky enough to catch any of the big commercial vessels. We also saw lots of birds & had a big sea lion swim right under the balcony. I doubt we'll be back any time soon only because it is very spendy and way above our usual budget, but I would definitely like to return some day for a special occasion again. About the only thing remotely negative that I would say is that a number of details on their website turned out to be incorrect such as it being dog friendly and binoculars being provided in the rooms. Nothing that bothered us, but I would suggest that you double check when you make your reservations about any details that you consider important.
This review is the subjective opinion of a TripAdvisor member and not of TripAdvisor LLC