I've lived in Utah nearly 20 years and skied all these mountains extensively. First of all, Park City fits your requirements. There are three huge resorts that will, at your skiing levels, give you everything you're looking for and more. The notion that there is no expert terrain or that the snow isn't fabulous in Park City is silly. People who dis the PC resorts clearly haven't explored them. Solitude is a cute mountain in a cute little village, but isolated with a couple restaurants, a ski shop or two, and no nightlife. Same with Little Cottonwood. Alta and Bird are steep, expert athlete oriented resorts with zero nightlife, no shops and few amenities. Alta does have a good beginner area and both Cottonwoods are beautiful, but they are about skiing, nothing more ( or less)
The Ogden resorts are beautiful but also isolated. Snow basin has no actual village at all and Powder Mountain is quite rustic with few amenities. The Lakeside Condos you mention are literally miles from anywhere at all...lots of cows & ranches up there, few people or groceries....
The best advice I've read here is to find a reasonable rate in Old Town Park City or Kimball Junction ( the newer part of PC) and if at all possible, rent a car. You can easily visit the Cottonwoods and the Ogden resorts and the scenery on the way is breathtaking. The dumb airport shuttles cost almost as much as a car rental anyway. You will only need 4 wheel drive if it snows heavily, and if it snows heavily, take the free town bus and go straight to Deer Valley. It rocks on a powder day and your wife will love it.
Awesome. Thanks a ton for this advice. So if we stay in Kimball Junction or Park City, there is a bus to take us to Deer Valley?