I can only speak from experience.
First, what we do now, when we go from IL to FL.
1. Call the city, and have them turn the water off at the line that runs from the street. Four feet underground.
2. Shut off toilet valves, flush and drain tanks, open faucets. Turn off main inside house.
3. RV antifreeze into toilet tank, bowl, and all sink drains. (not much... one gallon for whole house).
4. Leave furnace on set to 45 degrees.
5. Using remote thermometer, give receiver to next door neighbors and transmitter in center of the living room. As a back up to this, a thermostat with a plug in for a lamp that we put in the window facing neighbor's house.
Now, if this seems like overkill, it takes about an hour to do it all. The heating bill comes in at about $30/month. The cost of the antifreeze is $3.
Now... why?
For one thing we are well aware of the potential for flooding. In Florida, a helpful neighbor decided to turn on our water to freshen the flowers. (sprinklers on a different system)... Riser to the toilet broke and filled half the home with water $9K damage. that wasn't freezing but....
Second... many years ago in Illinois. Just on a weekend when we were away in winter. Furnace went off, and the main water feed from the street froze, and the pipe burst... before the main valve. Flooded the basement. Not too bad, but a lesson learned. As long as the water coming into the main shut off is still under pressure, nothing to stop flooding... the reason we have the city shut off the water underground. No charge, and we have to call the day before we return to have it turned back on, but a mior incovenience.
Not to overdo this, but our current home is on a crawl space, same as all the homes in the community. Three years ago, during a very hard freeze while a neighbor was away, the feeder pipe burst, even though the main had been shut off, flooding the crawl space. Seemingly no serious damage, until the foundation and the under house supporting columns shifted, and caused major total house structural damage. Wall cracks and vaulted ceiling serious cracks and movement.