I'm using a Kickr SNAP, never had a flat or even came close. Noise not an issue, it is in the basement.
If you really want to talk yourself out of it, think of how much you could upgrade your road bike with $800, less a few bucks to hand out ear plugs to those who the noise is bothering...
I'm using that strategy to talk myself out of buying the Stac Halcyon wheel-on trainer that used magnets and wheel weights, no contact to the tires. The bike I use on the trainer is my 1995 Trek 520, which I still ride outdoors sometimes, and during the summer I occasionally want to get on Zwift on a rainy day. The Stac Zero would eliminate all the tire or wheel changing, as would a direct drive (at a cost of more $$) - but I really just want to see how that technology works.