In my old house, I had prefinished engineered flooring with my 300 gallon tank. Floors held up just fine with the tank (different story with the rambunctious dogs, one being a Dane mix, @180lbs). Had my fair share of spills. Wood floors are quite resilient as long as they are maintained(finish not worn to bare wood). Different floor finishes have different care requirements, I'll try not to bore you, I can talk about this all day (been in the wood floor business over 20 yrs). You are right about quality products, flooring is no different. You usually get what you pay for. Engineered flooring especially. One of the main things to look at is the wear layer(top layer "hardwood"), cheaper floor have this layer paper thin, while better quality floors have enough wear layer to be refinished at a later date. I try not to sell anything less than a 2mm. 80% of our residential new install are unfinished (sand&finish in place) with at least a 4mm layer.
There are never any guarantees of a tank overflow, but I've seen more wood floors ruined with potted plants than fish tanks, lol ! Wood would probably be the most expensive option(there are so expensive tile out there though), but I wouldn't completely rule it out. My wife always jokes with me with every new scratch or imperfection, that I can fix it, but just because I can, doesn't mean I always want to.
Seeing that you're going with a professional, I'm sure there's bound to be people locally to help with your decision. If you happen to have any questions( I'm more of an expert on all things wood floors, but can usually point a good direction for most other solid surfaces), don't hesitate to reach out. I agree to get more of what you like, and not place too much importance over the moisture side of things. Barring a real catastrophe, most solid surface flooring can hold their own. Be careful with laminates though, as most have a MDF (medium density fiberboard) core. Most laminates will suck water up like a sponge and swell up and get ruined pretty quick.
