I've lived here all my life and had never heard of it. From their website, it looks like it's at MCRD. I thought most of that was gone now in favor of Liberty Station, but I think some of the buildings are still there.
OP, I don't know anyone's whose been there, so I can't help much. It's closed every Sunday and I did find one review that gave it four stars, but it looks like they were there all day.
Their website is here if you need dates and times and all that.
http://www.corpshistory.org/Home_Page.html