Don't worry about getting lost, that's the most fun! I also live in SF, so just say what you're interested in and I/we can guide you.
Only thing I'd say to avoid as a first time tourist is a neighborhood known as "The Tenderloin."
But, in general:
Alcatraz
Twin Peaks
GG Bridge if that's your thing (biking across to grab dinner in Marin County can be nice)
EAT
DRINK
I like to just wander to neighborhoods and wander around to see what places there are to eat/drink.







