I am just an occasional (by land) visitor. I have also participated in one delivery there of a 30 foot sailboat from Portland. The bar is considered to be one of the easiest (and shortest) bars on our coast. There is sailing on the bay, albeit more at high tide. It all shoals quite a bit going up to the end at Toledo, and is kept navigable to that point for barge traffic, AFAIK.
Promoting safe water sports and recreation in a friendly atmosphere.
yaquinabayyachtclub.org
FWIW, the bay has more sailing room for your boat (4' draft) than it would offer for mine (6' draft........)
They do have a racing program. If you want to sail/motor up to Astoria it's an overnight trip. It has been years since I walked the docks, but I recall that there are two marinas there. The YC does not own a moorage facility, but does have a nice clubhouse. Note that, like much of the Oregon and Washington coastline, it tends to be a lee shore and there are few nearby places to duck in to. The local's at the YC can fill you in for the other 99% of the details.
The Oregon Hiway Dept has a couple of cams on the scenic bridge, and here is the main "TripCheck" link. look for the Hwy 101 cams.
www.tripcheck.com