For Moab, I think the most impressive drive for views and sheer pleasure is to take the Shafer Trail down to the White Rim trail and then to Lathrop Canyon. That drive will take you from the very top of Canyonlands all the way down to the bank of the Colorado River.
The Shafer Trail is an easy road. I have seen everything from a European station wagon (don't recall if it was Volvo or Mercedes) to a 2wd Dodge dually. The only thing challenging about it is if you are a flatlander and have a fear of heights. The White Rim from there to Lathrop is even easier. Lathrop itself may be mildly challenging, depending on what the rains have done to it. You can figure that out with a 15 minute walk when it drops down into the wash that will run to the Colorado River. That section where it drops down is where the challenge (if there is any) will be. Scout it on foot if you are concerned.
Note that the Shafer Trail is part of Canyonlands and you will need to go into the park to get a permit to run it. I think the permit is free (it used to be). More than anything they are trying to control the amount of traffic on the road. They may also have a requirement that you have a vehicle with low range. That is about the steepness of the grade. Trying to ride your brakes down the hill would be a bad idea.
That drive may not stack up to a helicopter ride, but it is as close as you can get and still be in your vehicle (and survive--I guess Thelma & Louise may have gotten closer, but I assume that is not your plan). You will be driving switchbacks from the top of a sheer cliff to the bottom. The views do not get any better.
La Sal Pass would be the next drive I would consider, but talk to the local Rangers about trail conditions. When I did that one in October of 2018 there was a substantial rock slide to get over, and the snow at 9,000' wound up being too deep for us to get any farther. Nonetheless, we had some great views.