I booked a block of rooms here for my wedding at Robin Hill Park, which is only a mile away from this hotel. I also stayed here the night before my wedding as well as during my wedding night.
The Sheraton was great to work with under these circumstances. Even though I didn't fill my room block, they still treated us very well and we were able to use the hotel shuttle as transportation (we just had to pay a small fee). The hotel has just been renovated and is very comfortable, although the soundproofing is not quite capable of dealing with five teenagers from a random basketball camp if they happen to be rooming next to you. (But is any wall thick enough for that? Probably not.)
All in all, I recommend this hotel if you need someplace convenient to the airport, or destinations in Moon, Coraopolis, or Sewickley. It is a bit far from Pittsburgh to be an attractive spot for people who are visiting the city for an extended period.