South Lake Tahoe is great if you’re going to ski or snowboard but I’d not go just to see the scenery. Don’t get me wrong, it’s incredibly scenic but not worth the five or so hour drive from SF. The first 3 or so hours of the drive aren’t great either, just freeway and only the last hour or so is in the mountains.
Even if you are going for skiing, be warned that they close the roads at short notice and are strict on enforcing chains. And Heavenly resort have a reputation of closing due to wind at the drop of a hat. Oh and it does get busy at weekends, though we were there for Presidents weekend so busier than normal.