We had an acquarium pass one year, and used it three times just because I really forced us to do it. It's fun, but not worth lots of repeat visits.
On the other hand, we currently have a Maryland Science Center museum and we've been ~4 times and still haven't seen it all and the kids (ages 7 and 10) are still excited to go back.