Cycling is however a lot more interesting if you have somewhere good to ride.
Rowing machines are fine. I'm not sure why they have a he-man scale going up to 11 when the on-water experience is mostly below 4, but I guess people need goals. Bad back goals.
There's a big difference between air resistance and magnetic resistance machines. Air resistance scales with the square of velocity, the same as real rowing, while magnetic resistance is linear. On an air resistance machine you can get a good workout by keeping the difficulty setting realistically low and rowing faster, but on a magnetic resistance machine you'll end up going so fast it becomes difficult to maintain good technique. The higher difficulty settings are more useful on a magnetic resistance machine.
That would make resistance training by rowing in water better fit than some magnetic resistance machine based on what you described. Air also has same property like any other fluid, your average big body of water has enough viscosity for this property to matter at speeds we don't need cybernetics and Tommy John's surgery to survive.
(1) A motor unit is just all the muscle fibers controlled by 1 motor neuron. With this single source of signals, all those muscle fibers respond the same way.
I do love just getting out and running though!