here’s no one answer for this. Magnetic models are going to be more quiet and probably last a bit longer, as they virtually require no maintenance.
However, air rowing machines offer a bit more resistance typically (though not a rule).