habe a read through that review for a brief heads up on the main players.
i think the QUIET turbos are of the fluid kind, noisy ones are the air resistance type ones.
i have had the Elite Elastogel Power Fluid Turbo for the past year and a half. Very happy with it. Its quiet enough to use in the living room whilst watching tv and not have to adjust the volume of the tv.
one thing I'd advise is to see if the turbo you choose is on the list of trainers used by Trainerroad.com Best 55 quid a year you can spend if you're getting a turbo, IMHO.
Im looking at upgrading mine soon to a Wahoo Kickr.