Kiyomizu-dera is without a doubt one of Kyoto's most famous temples. As a result of it being one of the most popular tourist destinations, it is often crowded with people. However, the autumn foliage light up nights are worth going to despite the crowds. The iconic view of the wooden temple sitting amongst a sea of lit up autumn leaves is beautiful, and walking under lit up maple leaves at night gives a much different atmosphere and experience than walking under them during the day.
My only warning is to definitely be prepared for crowds!