Count me among those interested in the smaller stuff too. There are several around SOMA I've been meaning to look into, shoot and post about here. One of these days...
The Transbay Blog has a rundown of some additional projects toward the bottom of
this page. They cover two projects in the Tenderloin, including the offsite affordable housing for Millennium. The other is senior housing that looks really interesting: 990 Polk. I hadn't heard about that one before.