I stayed here for 2 weeks while traveling on business. I stayed in one of the remodeled rooms, and found it on par with places like Aloft or The Element. The remodeled rooms have a familiar boutique feel. The exterior of the hotel is cute and clean. At the end of the day, this is still pretty much a motel, but about the nicest one you could hope to find.
The neighborhood is quiet and provides easy foot access to several dining options, including Half Moon Bay Brewing. There is a coffee shop basically next door to the place that offers food and beverages. I had no issues with hearing noises from adjacent rooms and found the service friendly and helpful. The hotel breakfast was underwhelming, but I wasn't expecting much, so it wasn't much of a disappointment. I went next door and ate there or else drove into the city early and got breakfast.
I was not bothered by the foghorn, but I think a light sleeper might have an issue with it. You can definitely hear it in your room. To me it was just part of the package.
Overall, this was a much better place to stay than a crappy corporate hotel in the core of the Bay Area. I commuted to Redwood City daily from here and had no real issues. It took about half an hour when leaving by 7:30AM.