I know you're talking about doing this at scale, but FYI: Muni buses in SF already provide this service. Nearly all have 2 or 3 spots for bikes on the front and you can throw your bike on and take it up the big hills for no extra charge.

For the route you posted, the 48 does exactly what you want.