I've been by it a few times, it is kind of BFE as far as being close to anything major, but it's on the coast and kind of centeralized between LA and Frisco. Between those two locations there's TONS of great riding. If you're into sand dunes Pismo isn't too far away, and since it's on the coast there's always gonna be some kind of fishing/diving etc. through the MWR on base (get certified if its cheap). I love the San Diego area but I'd take Pt Hueneme over 29 Palms, or San Diego in a heart beat (currently stationed at Miramar), or Lemore (I hear it's worse than China Lake / Ridgecrest)
Good thing about it is a lot of the LA things tend to end up running north, so when the guys need to GTFO the're gonna be headed more towards your way.