I've never been involved with a production. However, I've adjudicated two community theatre productions of it, and it was a rousing success each time. The community theatres weren't large (maybe 200-250 seats each), but they had very good houses when I was there, and the audiences just ate it up.

If you do it,  be sure to advertise geared to the younger people as well as older (sort of a "what is your mom and dad really thinking" kind of thing) ... this play's humor and emotion was not audience specific. I would liken it, for an extreme example) of a kid's play like "the Lion King" which adults also love.