Ah yes, the chaos monkey approach to plumbing. I buy it. The best time to have a leak is during or immediately after doing plumbing work. The worst time is when you are asleep, out of the house, or on vacation.

Isn't it code nowadays to have water hammer arrestors that trap air and create a cushion?

Plastic piping (if equipped) functions as a water hammer arrestor. An expansion tank will as well, though a picky inspector may insist that the automatic valve location must have a water hammer arrestor if you are piped with metal supplies.

I know expansion tanks are required by IRC these days and those can help with hammer a bit too, as they're doing a similar function.

It happened to me once, now I turn off the water when I go on vacation.

you don't have embedded copper water lines in concrete slabs I assume? sure a little drywall damage is nothing but having to jackhammer that up is a bigger ask.

I've seen people just abandon those lines in favor of running pex through the walls rather than fix them.