I had a Rotel RCD-1070 from when it was new in 2002 (wedding gift) until a year or two ago when I replaced it with an RCD-991AE.
It's hard to know what would be helpful to to tell you b/c it so depends on where you're coming from and where you're going.
It was the first CD player I ever got that was better than the average $30 yard sale player. And it was like crack or whatever. You can't unhear that sh*t. I had no idea all that smooth resolution was on those little silver discs! But that experience is very much relative to what I had heard up to that point.
The Rotel delivered clear, full-scale images across a cohesive soundstage. It didn't seem to have any bad habits; no etch or glare and good bass extension. I used it with a few different integrated amps over the years and with different speakers too and it always resolved well enough to evaluate any changes downstream.
All this to say, I really liked that Rotel. I kept it a long, long time. In fact, it was the last thing I upgraded. Everything around that Rotel got better and better and it held its own right up to the point where I took a casual listen to the RCD 991.
Once I heard the RCD-991AE in my system, it was an easy decision to sell the RCD-1070 and buy the 991 even though it was about 4 years older. The 991 has all the strengths of the 1070 but has a better ability to open up the soundstage and also fill out the images of individual instruments.
I sold the 1070 to an appreciative friend for $225 and bought the 991 for $325 used from my local shop.
All this to say. I've enjoyed Rotel CD players and would recommend one. The 1070 is a very, very good player IMO. It was at $600+ new, and it's only a better deal at current used prices. And if you can afford a bit more for an RCD-991, that's worth the extra stretch. But if not, there's no reason I can think of why you should feel anything but excited to have a 1070.
(BTW, I did have to change the load belt for the door of the 1070 after about 8 years. The belt was available from Rotel and came with a clear, color PDF set of instructions. (It's uploaded here in digital docs I believe)