I took the Kyoto palace tour on one of the public open days -- there are a few scattered throughout the year, I forget when. Still not allowed into any building but they said more doors were open than on the regular tour so we could see into more rooms. I'm with those who thought it was only mildly interesting.

Katsura Imperial Villa has to be booked online months in advance.