I will preface this review by saying that neither my fiancé nor I had ever been to San Diego, so we had no idea what type of location and neighborhood we would be staying in. When we booked this motel, all we knew is that we were not very far from the airport and the motel was very close to all major San Diego freeways.
We arrived at the Courtyard around midnight on a Sunday night/Monday morning, and check-in was no problem at this late hour. I had booked the room through Priceline.com (for about one-third of the going rate, by the way), and after reading other travelers' reviews, we expected to get a room on the ground floor facing the freeway. We were pleasantly surprised to find just the opposite: we were given a room on the fourth floor, facing away from the freeway and looking inland. Therefore, we experienced absolutely no noise problems from either the traffic or the remodeling that was going on in the hotel.
We essentially used the Courtyard for sleeping since we had activities planned during the daytime for our entire stay, but when we did hang out at the hotel, we found it to be very enjoyable. The staff in the bar/restaurant was accommodating, and we had no complaints about our stay whatsoever. There was a large group of high school baseball players staying there at the same time we were, but other than the small outdoor pool/hot tub being crowded at times, we barely knew they were there.
The main attraction of this hotel (for us) was the proximity to the Old Town district, which was a 5-minute walk away. There are several bars and restaurants in this area, and many of them offer weekday happy hour specials, which made it all the more enticing.
One tip to future travelers: The Courtyard charges a daily fee to park in their garage ($12/day, I believe), which can easily be avoided by parking on the street in the surrounding neighborhood. Since the hotel borders the freeway, the surrounding streets are mainly dead ends and very quiet, and we had no qualms about parking our rental car there every night of our stay.