I'm probably the last person you should listen to (you'll see why) but I LOVE my rower!
Last year I was mostly using my road bike on a fluid trainer for workouts. It was literally over 110 here for months on end so I had limited options! Eventually bought a spin bike because I got tired of taking the bike on and off the trainer.
Started looking at rowers because I felt like my legs were getting so much work all the time but not my upper body. I'd literally NEVER used one before and then bought a Proform 750R. There's a store in my area that sells manufacturer returns and liquidations, and I got this one assembled and delivered for around $400.
It can be used on its own or has a tablet holder and syncs with the iFit app. iFit programs adjust resistance automatically. They have outdoor and studio workouts.
Initially I tried a few YouTube workouts to get the form right. My Endurance Check-in ladies also gave me lots of tips!
Concept 2 is the gold standard. It has a chain which is supposed to last forever but can also be noisy. Mine uses a flywheel and belt, similar to my spin bike, so is relatively quiet. It uses magnetic resistance, also like my spin bike, whereas Concept 2 uses air resistance.
While I LOVE my rower, I would say try one out if you can. I'm glad i didn't get the super cheap ones I initially looked at and also don't feel the need to spring for a fancier one.
It absolutely is a good full-body, no-impact workout. Form is super important--if it's off even a bit your hands, legs, back, everything will feel it.
I did a 4 week iFit series that was rowing workouts that had off-machine bodyweight exercises. It was an amazing workout without being exhausting, and I really started to see some upper body definition.
Oh, and my rower does fold up and store sort of vertical so it could sit in a corner of the room. It's kind of heavy though and we don't really use that space for anything else so I keep it open. Nice to have the option though.
No idea if that helps!
I'm glad to answer questions though.