DH and I took the tour on our honeymoon. It was great! There were only 4 of us on the tour, and the other two people were cast members so we feel as though it was a little more magical. We highly recommend it.
I went on the tour in February and it's definitely worth the time. But no, it's not offered more than once a day. It's only available on EE days, and you're basically getting an EE into the park to go on the tour.
What exactly details the tour? My dh is a Walt NUT. New people thought we had a picture of his grandfather up. It was Walt. We finished our basement so he can have his "shrine"/movie room.
Would my ds6 and I enjoy it? We're all huge Disney fans, but does it go behind the scenes anywhere?