@cicerone imposter,
Astoria has been called "Little San Francisco of the Pacific Northwest." It has a quaint downtown area that is established with retail shops and restaurants. Our first night was spent at the Red Lion Inn Jantzen Beach by the river not far from the boat. The Queen of the West is a paddlewheel riverboat that can accommodate about 150 passengers. It is decorated in the Old West style, and our stateroom was large enough for the two of us since we spent very little time in it. The passengers were from all over the US, and we met people from Florida. The cost for our stateroom was $4,270 per person plus port charges and fees of $500 for a total of $9,120 which translate to about $500 per person per day. Included in the price were many complimentary shore tours, three gourmet meals a day, and we did not have to add gratuity. We started in Portland, cruised west to Astoria, then turned back east to visit Mt St Helens *Day 3 (most of us remember the 1980 eruption that scorched 230 square miles of forest land, Multnomah Falls (our second visit), Stevenson *Day 4, The Dalles *Day 5, Umatilla, Pendleton *Day 6 (we paid $80 pp for the factory & shops visit), Richland, and Clarkston *Day 7. At the end of the cruise, we were bussed to Lewiston, then a flight to Spokane and Seattle, before our final flight to San Jose (home). All in all, I was pleased with the whole experience.
A correction: The Lewis and Clark spent the winters of 1805-1806 (not 1808-1809), and Astoria was the first settlement west of the Rockies. I'll add some photos after I learn how to transfer it from my iPhone and camera.