Cannon beach is nice, and lots of lodging options.
My favorite part of the Oregon coast is the central coast, and recently we've tried both Adobe Resort and Overleaf Lodge in Yachts (north of Florence). Both places are nice- can't beat the views and location to storm watch. Small town, but plenty of places to eat. Florence is to the South, and Newport to the North- both close enough to drive for a meal. Cute shops. Adobe Resort has a restaurant, Overleaf does not- but does have continental breakfast. Very relaxing to jsut sit and watch the ocean, go for walks, etc. It's like being in a different world. The Sea Lion Caves are nearby and can't be missed! Along with Heceta head light house- a short hike out to the lighthouse.
Also, if you want to splurge 1 night on the way down or the way back, stop in Astoria and stay at The Cannery Inn. It's right under the bridge, built out over the river, right on the edge of the shipping canal. They provide binoculars and it is so cool to see the cargo ships coming in over the Columbia bar and watch them come towards you and go right by you on your deck. Not cheap, but worth it for 1 night!