Not an expert on trainers, so I will offer only what my limited experience tells me. First, fluid trainers are quieter than magnetic. Second, I would suggest getting a smooth tire for the rear for trainer use, and make sure the adjustment is only tight enough to prevent slippage.
Beyond that I bought the base model fluid trainer from Performance and am happy with it, but I don't have more than a few hours on it yet and it's my first experience on one so don't take that as a serious recommendation.
__________________
Tom
"It hurts so good..."