Coincidentally, I am visiting southern CA for Hackaday Supercon in Pasadena and went to the Huntington today. It's incredible! I would go all the time if I lived here.

Yup, the day ticket can feel a bit expensive, but the membership is pretty cheap in comparison. Both definitely worth it (and I think you can chip in the value of your day ticket towards a membership)