The best rower is the one you use!
I got a c2 during covid times. A lot were still on lockdown but I was working so bought one for fitness. They were like hen's teeth and it took me 13 weeks or longer for it to turn up. I put it together and did one session then the next day I broke my arm in a cycling accident on my week old Brompton! It took 7 weeks before I could row without my arm hurting.
I did a few sessions then it got folded up into the corner of the dining room. As one last bit of rowing related mishap our garage under the house developed a spring that flooded it out. Since that was going to be my pain cave with rower, turbo and weights it also scuppered our plans.
Needless to say we wasted money on it but I know one day I'll get back into it. My point is that if you are really going to use a rower then IMHO a concept 2 is the best option long term. Cheap will not be repairable like C2. Indeed I'm not sure water rower is as repairable but at the same sort of price they should be.
The big thing with c2 after repairability, durability and actual performance/feel, is the way the pm5 controller links in with various things. You can link to heart rate strap, phone or tablet and also computer. This means you can take simple or more complex approach towards its use. I used it to record the workout and link it into garmin connect. You can also program the pm5 controller for a workout. C2 also publish workout of the day (WOD). This gives three workout levels according to fitness. There's also training plans similar to the couch to 2k running plans. You can program the controller yourself or press a provided button order to set one up from c2. That then tells you when to push and when to ease up and other elements too.
I know the OP isn't planning on being a hard-core rower but the ability to do this and more future proofs the equipment. You might want to do more later.
There are other kit you could get. I quite fancied the versaclimber.
Versaclimber