This is a fun place to go. It's just on the other side of the peninsula from San Francisco, and yet it feels like it's in a different world.
It's a really nice little airport. There is no jet fuel, and no FBO to speak of (there is a nice little airport restaurant, but that's about it). As I recall, there is a parking area on the other side of the field where you can walk through a gate and into a little shopping area, but in recent years I've always parked over by the restaurant.
There is a wonderful Ritz Carlton in Half Moon Bay, and if you have a chance, it's definitely worth spending a night. If you are more budget minded, there is the Half Moon Bay Lodge, which is quite nice and is on the corner of the road leading into the Ritz Carlton. You can walk to the Ritz from there, and enjoy the views.
Going in to Half Moon Bay is pretty straightforward. There is a decent GPS approach, but in the morning and late afternoon, fog can be an issue. When departing, watch out for the San Francisco Class B-- you need to fly out over the ocean for a bit to stay clear of it.