I stayed at the Courtyard Marriott for 4 days for business. The staff are extremely friendly and welcoming and the rooms are very clean. The breakfast bar was varied and affordable and it was located right next to a sportsbar which is good for evening meals. Free high speed internet is awesome! They have a handy shuttle service that will bring you/pick you up anywhere in a 5 mile radius (the driver was extremely friendly and talkative - kudos for employing some super great staff!). The shuttle is a great perk especially since I was told that taxis aren't readily available in the area.
The only downside to the hotel is that if you're coming from the airport, it's about a 50 dollar cab ride. I went to the information kiosk upon arriving at the airport and there is a number to ring where a free shuttle service operates to 4 of the Marriott's in Salt Lake but not the Sandy location. Heading back to the airport after my trip however, the staff was really helpful to organize a paid shuttle express service which was more economical at around 18-20 dollars.
If I was going back to Salt Lake again, I would enjoy staying at this hotel again and would recommend it to others.