I really don't think the scene has dried up; I go see live music several times a month in the city!
I don't know anything about getting booked at clubs, but there are still great places to play in the bay:
Bottom Of The Hill
DNA Lounge
Rickshaw Stop
Hemlock Tavern
Bender's
Boom Boom Room
Brick...