@sbright When are you coming to the Bay Area?
The SF Bay Area is probably one of the top cycling meccas in the world, particularly for road biking, so your options are enormous!
I live in Los Altos (you can check on Google Maps; I’m closer to the hills where you will be heading). I’m “a climber” and have probably logged 50Kmi+/5Mft+ in the Santa Cruz mountains over the past 15 years (where your rides are heading) and know the roads and routes “pretty well”. At minimum, I could provide you feedback/suggestions on routes. But if timing works out, I’d be happy to join you. The route you provided for example, is a good one, but includes a lot of Route 1. It’s great for seeing a lot of coast line, but riding along the highway may not be as much fun as the inland roads through the redwood forests. A more popular ride that includes the coast is aptly named “The Coastal Classic” (a 50mil/5kft loop) that is easy to add on an extension to Half Moon Bay (fun, great stop) or south through Pescadero (mentioned elsewhere) with 25-30+ more miles and a few Kft of climbing. btw: no worries about food/water; any route through the SC Mountains can be designed to provide sufficient stops.
Regarding group rides, there are a several cycling clubs in the area, ranging from recreational to elite racing clubs (I ride with one of them, Alto Velo Racing Club). Most group rides are on Saturdays and Sundays and are open. There are a several weekday rides as well. So it really depends on your cycling skills as to which ride to recommend. Some one mentioned the Noon Ride. Tue, Wed, and Thu are fast (Cat 1/2/3 pace). Mon and Fri are more social Cat 4/5 pace. Also during the week is a Cat1/2 level ride called the morning ride (TMR). For long rides, Wednesday there is a ride called the Stahl ride (70-100mi; 7k-9kft) that is open. It’s a social ride for Cat 1/2 level and ex-pros; and when not in race season, lots of current female world champion level riders use it for base training (i.e. its fast if you are not at that level).
DM me if you want to discuss further. Also, if you send me a link to your Strava profile and provide me with your WpKg, I probably will be able to get a better sense of your riding level to finer tune any recommendation(s).
Btw: The Marin area (North Bay) is fantastic as well. Lots of big loops up in that are that include the coast, Mt Tam, Alpine Dam, riding along the ridge (aka the Seven Sisters) is fantastic! Happy to put together a route for you up there, or similarly, if timing works out, happy to take a ride up there with you.