Utah is beautiful. I lived there through junior high and half of high school. My family has also lived in the area- some of them up to 2004. It could be a great place to live. We were in the 'Sugarhouse' area a few miles from downtown SLC.
One thing I would be mindful as you pick a community is the religous diversity in the neighborhood you choose. If you are not Mormon, you will want to make sure there is diversity where you live. (When I was there SLC was 50/50 so it is not that hard). My experience was the Mormons were very friendly but it is also a tight knit community who plays and worships together several times a week. In some areas is it hard not to be part of that group. In some instance you can feel / be excluded. My parents neighbors had a little girl - as she got older (maybe 3 or 4) and she was closed out of play groups / not allowed to continue to play with some other kids because her family was not Mormon. My sister was the only non-Mormon on her street and they were excluded from several neighborhood activities. But - she would still move back and thinks it can be a great place to raise a family - just pay attention as you select your home an neighborhood. For me, it was a good place to grow up - and I had great friends both Mormon and non-Mormon.
I was there in September for my mother's funeral and we enjoyed our visit. We are also considering a move and it is on our list of possible destinations as well.
Good luck,
L.