I feel your pain. Ever since they stopped stocking the Clackamas with trout in the 90s I have wished for close in river, trout fishing again (I don't count the damned up parts of Clackamas as river fishing). It seems like around Portland the Salmon/Steelhead fisher people get all the best...
I caught a steelhead on a fly rod once. Was definitely a highlight of my fishing experience. I have made a yearly goal list but not a lifetime bucket list. Good idea.
I am going surf perching in a week. Saw some people on You tube using artificial sandworms like Berkeley Gulp Saltwater. ODFW also recommends this https://myodfw.com/articles/how-fish-surfperch