We've been pretty lucky.
We've had one house for 20 and the other for 10.
So far we've had tenants who-
1- Took window treatments and decorations that belonged to us, and kept a rabbit without telling us
2- Tore up random 5 foot sections of the carpet and put down stick on simulated wood tiles at odd angles (those folks also left a pile of past due notices- I mean a PILE, along with receipts for brand new ipads and iphones, and new car payment books along with missed payment notices for those) and tried to steal our stove and called the police on US, who came just as they were trying to wheel it into the U-Haul!
3- Fired a gun into the door knob on their way out causing the bullet to go through the refrigerator, three interior walls, and two interior doors
4- Stopped paying rent after a year, and patiently waited for the legal process to grant us an eviction after almost 3 months, then moved out quietly the night after we posted the notice. Their response to our inquiries was -"what do you want us to do, give you all of our money?"
(interesting note about these folks- after they moved in, her parents immediately downsized to a one bedroom house....gee, I wonder why?)
But...we had one family that stayed 9 years, and they basically paid for that house.
We had another lady that asked if we had an early termination clause. We hastily added one before she signed the lease, and 2 months later, she violated it and paid us 500 bucks. I guess we owe her thanks.