Squaw and Northstar are the best for a ski in/out experience. The villages at the base of both places have plenty of restaurants and the accommodations at both places are great, I like the village at Northstar at little better but the terrain at Squaw is definitely more challenging. Mid-week the week after New Years it usually great, the crowds die way down from the holidays. If you can swing the $$$, the Ritz Carlton at Northstar is a cool place to stay, it's a ski in/out hotel up on the mountain and you can also ride down to the village or catch a gondola.
Drive from San Francisco to Tahoe, by the time you go through the airport hassles and drive from the Reno airport you could already be in Tahoe.
And finally, don't call it San Fran, or Frisco.