Pros: Skiing. "The greatest snow on earth" is not just a marketing slogan.
Cons: Air pollution. It's a valley, and all the pollution gets trapped in the valley and can stay there for days.
Cons: It's less Mormon than the rest of Utah, but still Mormon enough that, if you're not Mormon, you can find it kind of stifling. (But pro to the con, or credit where due - it's part of why it's such a safe city for it's size.)
That bottom link says Salt Lake is below the national average in violent crimes, but higher in property crimes. Well, for "dangerous", I think of violence, not property crimes.
Pros: plenty of tech jobs, mountains and national parks right next door, very clean and safe city, healthy and well educated population, delta hub.
Cons: the lake may kill us one day, or the house prices.