It just depends of what level of risk we all want to accept. Never had any issues but next time out ??? Do we turn the water off at night in the camper it could leak & I would sleep through it. No. Slept through a tornado years ago.
Never had a leak but it could. Have had more leaks in the house I had to replace all the copper pipe due to pin hole leaks. The hot water heater leaked once all over (We were home & it made a nice little river in the basement) it was 25 years old. (& no I never drain it) The current one is well over 10 years old. We leave the water on at home so the animals left behind can be watered.
We can go outside & a plane could fall out of the sky, could get struck by lightning, a tree could fall on us, even could be run over by a crazed golf car driver but we still go outside....
I guess I am one of the people that will not turn the water off when gone until it happens.......but then I will just forget to turn it off.........I have alot of senior moments
What ever works for you is best.........