I have a 75g on hardwood floor in my living room, and a 125g in my tiled foyer for 10+ years. Nothing can protect the hardwood or tiles if you have flooding. So I take serious precautions to prevent flooding and spills.
First, avoid canister or sump system that has external plumbing. Sump and canister have external hoses that can be dislocated, and canister has seals and O rings that eventually will fail that can drain the tank if not discovered early. HOBs have no external plumbing and are much safer, except for the AC design that has an O ring at the motor that must be removed in cleaning the impeller, and a popped up foam that can drip to the floor. Even a tiny air pump hose can drip and drain a tank if you omit installing a check valve.
Second, be extra careful in WC. I place towels on the floor to soak up spilling, and always set up a timer in filling up the tank to warn against overfilling. I set the timer by measuring how much rise in water level in 5 min and projected the time to fill to the top. Before I set up the timer warning, I had overfill accident in my basement tanks due to distraction of a phone call or my wife called me for an errand.
Third, don’t buy used tank for placement in flood vulnerable area. You don’t know the history of the tank, and even the tank holds water at the seller location, the moving can break the seal. The larger the tank, the greater the stress on the seal in moving.