The Courtyard is not a terrible place - we stayed here in between flights going down to Costa Rica (to avoid the redeye to Houston). The lobby has been renovated with the "Bistro" but it doesn't seem like the rooms have gotten the similar treatment. They weren't horrible, but not as refreshed as some of the other Courtyards I've stayed at.
The hotel was very competitively priced (compared to other IAH hotels that I've stayed at) which made it the choice. As other reviewers have stated, they aren't really close to much, so if you don't have a car, you are pretty stuck (not that many of the other local hotels are much better). Luckily, the Bistro does have decent food options so not horrible (we usually just eat at Pappadeaux's at IAH when we do this, so no big loss).
The beds were reasonably comfortable and the shuttle service was friendly and made it easy to get there and back. They are a little further away from many of the other airport hotels (at least it felt like that on the shuttle!) but still only a few minutes away from the airport.More