The 'Pines' campgrounds in the valley are a very good spot and the free shuttle bus service is great for getting around the valley and don't miss going up to Glacier point, it's amazing !
If you are planning to drive the historic Columbia river highway into Portland [which I would recommend] then you might look at travelling a little further than Bend. There is a lovely campground in Mt Hood National forest at the 'Lost Lake resort'. It's a bit of a way in and out [about 16 miles each way] but it's a pretty cool and peaceful place. I have not been to Fairview RV but we stayed at the Sandy River RV resort near Troutdale which was quiet, clean and tidy.

If you don't mind the extra bit of driving then I would break the journey between Portland and Vancouver with a side trip to Mount Rainier.

Manzanita Lake in Lassen is a nice campground.