Two hours is fair if you are a dilettante like me. It depends on who goes with you. I tend to get lost looking at everything, but my family usually does not have the patience that I do. You can spend an hour playing in the gift shop if I remember correctly.
Definitely worth a visit every few years. I feel the same way about the RMSC, Eastman House, and Planetarium.