I loved this place.
My wife and I stayed here on our anniversary. I read some of the other reviews, looked at Google Maps to get the street level view of the location and figured to give it a shot.
It is right off the highway so it was easy to find, once we entered the hotel the people at the front desk were very polite and respectable.
The lobby and the bar look just like the pictures, bright, colorful and nice furniture. I think this hotel is pretty new, we went to our room which was on the 7th floor. Elevators are fast, only takes maybe 3 seconds, when we opened our room we had a king bed, chair with ottoman, 2 night stands a nice business desk, refrigerator that actually kept your food and drinks cold and the best part was the flat screen lcd T.V. I think it was maybe a 27 inch, lots of channels, digital and HD stations.
I used the business room a couple of times, computers look just about new, decent internet speed. Lobby is nice, tables are already setup with silverware and coffee mugs.
Fitness area is great if your into working out, 2 elliptical machines, 2 treadmills and 2 bikes. 2 racks of dumbbells 5-50 lbs, bench, crunch machine and a vertical knee raise stand.
All of the cardio machines have there own t.v. mounted on them and the room itself has a large lcd LG T.V. mounted on the wall.
Pool looked nice, I saw a couple of families in there every night we stayed. Also, I don't know what the other people were talking about when they said the hotel is noisy because we did not here anything from the outside, the rooms are well insulated.
Only thing we did not like was not enough pillows on the bed, only one. Pillows are very soft but no support, your head sinks down to the mattress.
I only wish we knew about the breakfast, we did not find out until we were leaving the hotel. And it was not just cereal and muffins there was actually fruit, french toast, sausage, juice and other hot stuff.
Loved our stay there for the price, $65/night I think it was a great value. Next visit to Houston I will look for this place first.

Stayed here 3 nights visiting a customer in the middle of January, 2009.
Positives: Hotel has undergone recent renovation. Beds, refrigerators, work areas, bathrooms appear to be updated. Free coffee in the morning. Free business center with printers. Location is convenient at the intersection of 2 major roads, and many good restaurants within 5 minutes drive.
Negatives: Location is at the intersection of 2 major roads and just as previous reviewer pointed out - if noise bothers you do not even consider staying here. Rooms on the north side are particularly bad, since they face both Beltway 8 and Katy freeway. Rooms on the south side are just very noisy. It appears that the renovation was done on a very low budget. Here are the couple of examples:
1. Instead of replacing the refrigerators with specialized models that fit into the space under a small counter, like in any other hotel, they installed regular dorm-room style refrigerators that do not have any logical place to be located in the room. As a result they stuffed them under the work desk, making it not very comfortable to use the work area.
2. They have installed normal wood "frames" for flat screen TV's, like other Sheratons, except for the fact that they put 26" TV there at least 37" should be. So the screens look particularly small mounted on the large wooden frames.

I stayed here over Thanksgiving with my Boyfriend and dog. They were nice enough to upgrade us to a suite because of our dog and the front desk and wait staff were so nice! The room was clean and comfy. Our breakfast service to the room was wonderful and quick!

I also really liked their workout facility. The equipment is brand new and there's a great variety. I would definately stay here again.

...........traffic noise bothers you while you try to sleep.

The hotel is located right at the intersection of Katy Fwy. and Sam Houston Tollway. Rather, I should say the intersection is located almost on top of the hotel; the Tollway is almost literally on top. The first room they gave me (5th floor) faced Katy Fwy. The noise was awful. So I thought I would be smart, thinking the noise was from Katy and so I would move to the back of the hotel. So they gave me a room at the back. Smart, eh? Not quite, because then you get the tollway running through your room. I tried one miserable night, with no success. Back down again, pretty much ready to check-out. A very kind person at the front desk put me on the 2nd floor, as he knew the noise was less there (clearly a common complaint of the customers). Indeed, the (lack of) noise was much better.

The rooms (I saw 3) looked to have been refurbished. However, they already had an edge of being dated and cheap looking.

I did not try any of the amenities (restaurant, gym, etc).

The highlight of the hotel were the staff, who were all very friendly and helpful.