you want touristy? The city is OPEN LATE! I suggest possibly hanging out in north beach for dinner (its the italian part of town) also the strip joints are there. Also you might wanna check out the http://www.metreon.com/
this is Sony theater - mall deal. yeah its pricey and all, but its fun. also its like 4 miles down the freeway from "monster park" where the niners play. If you were gonna do the wharf/peir 39 sunday is gonna be crowded (especially if its a nice day and in october it USUALLY is) Peir 39 has a good arcade.
If your into any particualr thing, let me know. Personally I'll take haight street and the park over the peir anyday.