The Commodore is a great place to stay, as long as you understand what they're offering. The rooms in this re-done old walkup workman's hotel are simple, small, and tasteful in a contemporary way. Most are "European", which means the bath and shower are down the hall. Everything it very clean and tidy, so if this is an issue for you ... it's your issue.
We've stayed in both a small "cabin" room as well as a larger, corner full-size room with en-suite bath. When we do it again, we'll go back to the small room. Astoria is a town to get out and wander around, not sit in a room. The room is a clean, tidy place to sleep. If this works for you, you'll be happy with how nice the place is for the price.
The service was very friendly, knowledgeable, and helpful on both visits.