Since I solicited and received much appreciated advice from several of you regarding visiting San Francisco (and because I'm sitting in a hotel room bored out of my skull), I thought I'd offer my opinions after visiting:
Lodging:
1. Hotels were hard to come by for this past weekend and seemed inappropriately expensive. The cheapest place I could find was $169/night, with many of the hotels that were recommended going for $450/night.
2. Stayed at the Pickwick at 5th/Mission across from the old Mint and SF Chronicle buliding. It's an older hotel, so it wasn't made for the modern traveler. All the electricity and water and such had been retrofitted, wich was a little awkward, but overall it was clean and everything worked, even if it was a very small room. They told me the movie The Maltese Falcon was filmed in the hotel, which was cool since that's one of my favorite movies. The location of the hotel was great, just a block from Market St and a few blocks more to Union Square.
Transportation:
1. Easy drive from the Oakland airport to downtown SF. The hotel had parking for guests at $25/day, which seemed comparable to public lots throughout the city. Didn't drive any in the city, only took public transportation.
2. The public transportation is OK, I guess, but it's comically inadequate for the number of people. The shortest wait for any bus/streetcar/cable car was over an hour, with some being up to 3 hours. Cable cars are not really "public transportation" anyway, they're really just an amusement ride, though I suppose they do get you from Point A to Point B.
3. The streetcar stations are very poorly marked. You have to know where you are when you want to get off as there is no announcement or signage indicating at which station it is stopping. You just have to know, which is difficult for tourists.
Food:
1. Overall, the food was very good. Had Thai noodles for lunch on Friday and had dinner at Dante's at Pier 39 that night. Lunch at the Wharf on Saturday and (at the advice of Jim) dinner at Fior d' Italia on Saturday night. Had the veal at Fior and it was very good. Mrs. Hawk had risotto milanese and she said it was just like her grandmother's, who was from Genoa. The pasta fagioli soup was authentic as well. A couple of negatives about the dining experience though. Service was not a priority anywhere. Perhaps I'm spoiled in Houston, but waiting and hour and a half for your soup and 45 minutes to get your water refilled is a bit taxing. Speaking of taxing...you have to pay something called a "San Francisco Minimum Wage Tax" on your food. Not sure what that's all about, but that's life in the city, I suppose. The other negative out the dining was that the hours the restaurants were open seemed a little odd. We had a devil of a time finding breakfast before 9 am and it was impossible to get lunch before 11:30. Pretty much everything was locked up by 10:00 pm, so no coffee or gelato after dinner, except in the restaurant.
The Weather:
1. Was fabulous. They said the high was 63, but it felt more like 78. Sunny all weekend, no fog. I gathered that it was particularly nice, even for SF, so we were lucky there.
2. I don't understand why people walked around in heavy coats and parkas. I was in a long-sleeve tshirt or hawaiian shirt and it was very comfy. Any warmer, and I would have been sweating. Not sure why people acted like they were attending a Green Bay Packers game in December.
Errata:
1. Unbelievably crowded city. It's just a sea of humanity. It was more crowded than New Orleans at Mardi Gras. Made it difficult to get around.
2. Did the usual touristy stuff, Fisherman's Wharf, Alcatraz, Chinatown, Golden Gate, etc. Was pretty good, and we knew we were doing the touristy stuff, so everything was cool.
3. Alcatraz was really cool. The audio tour is really neat. I was amazed at how small the cells were. The entire cell is about the size of a queen-sized bed, and the inmates spent 22 hours a day in them. Brutal.
4. Mrs. Hawk couldn't find any Italian people, even in "Little Italy", which disappointed her. She wanted to practice speaking Italian.
A great time overall, and definitely a place to return to, though I was told other times of the year will likely be less crowded.
Thanks to all who provided the advice and recommendations.