We love Marriott's and this Courtyard was good. Yes, it has ZERO curb appeal, so if you're staying for long and hanging at the hotel, this may not be the place for you. It is convenient to the highway, with one way being a u-turn situation. But you can't walk anywhere from this location.
The staff was exceptionally helpful and accomodating. Everything was clean and fresh. Disappointing that they now are using "The Bistro" format and don't offer any type of breakfast included. There aren't any quick coffee/doughnut shops anywhere like there seem to be in the northeast.
Definitely a short-term, airport convenient type of place. They have a pool and hot tub, but the outside fire put was never on while we were there. Also, I wouldn't recommend for families. The kids would be bored.