Put me in the "Always out of the tank, never hook up" category, partly to avoid risk of flooding but also because it's just simpler when you do it the same way all the time whether boondocking or in a campground with hookups. I rarely stay in a campground more than a couple of days, so sometimes I don't use the on-site water at all. It's simpler to take out the hose and fill the tank when needed, and immediately put the hose away.
Also, if it's raining or cold or buggy or late on departure day, there's one less thing you have to mess around with when preparing for departure.