I have done it a few times
It has never been in a spiteful way. Most times it was just a fun prank for people we like and we help them clean it afterwards. I think it is a good thing to get your house TPed cause someone cares that much about you to mess with you.
Now a days I think that if someone wanted to be spitefull they could come up with much worse things then rolling your house.