Roughly, Brighton here is more like Sugar Bowl, Park City Mountain is sort-of Alpine Meadows, and Solitude is like Sierra at Tahoe. Alta is often compared to Kirkwood, and Snowbird to Squaw. Of course, these comparisons are not exact, but the feeling of these areas is close to the Tahoe "equivalents."
Where do you like to stay? If you want variety, staying in Salt Lake City will be similar but much closer than day trips to Tahoe from Sac. If you want skiing only, then Alta-Snowbird or Solitude would keep you at the base but little nightlife. Park City is best for ski-town ambience with many restaurants and bars, and three major ski areas within 5 miles.