If you are riding the river, no there will be nothing close to that. Nacimiento and San Antonio are the only close riding lakes. You might get a good set early morning on the weekends. If you are able to ride during the week your chances will be much better. If you really enjoy riding consistent good water without driving far, I would stay up there.
I live in Santa Barbara and have my boat at a private lake in Arvin, CA. This is the only way to ride good water down here. It is a 2.5 hour drive though, but you are guaranteed good water all day. If you move and want to ride, let me know. I am always looking for people to ride with.