noise is one thing, but a fluid trainer has progressive resistance so it mimmics a real road ride more closely, and good ones have a variable resistance level as well (mine has 5) as well as a wired or wireless cyclometer feature that measures things like calories burned, distance ridden, time elapsed, and so forth.
mainly I prefer the progressive resistance of a fluid trainer to the static resistance of a mag trainer.