Oakland Tours are the Bombdizzle by Scott Faust

This is late. Yay. This is probably my favorite site I've checked out so far. It seems made for users, by users. It has multiple tours based on themes of all sorts of interests. It gives you the chance to map your own tour by giving a story, and everybody can check out your tours and comment.