From the road, this place looks like a typical dingy roadside motel, but don't let that stop you.
Ask for a room overlooking the river. Those are in the buildings at the back of the property and have sweeping views of the Columbia. Our room was large, it had a refrigerator, a picture window, and a balcony. We could hear no highway noise at all.