Everybody's idea of off road is different so talking about how good the vehicle is, will be wholly dependent on your idea of off road.
Talking strictly about a
stock Ram they're not mud boggers, they don't have the tires for it. They're not rock crawlers, they're too wide for most of that and don't have nearly good enough approach angles. They're not desert race trucks, they don't have the clearance or suspension or tires for it.
If you put your definition more in line with whether the truck will be suited to pretty rough logging trails, routes to a fishing hole, quarry routes - they're not bad.
They have available skidplates that protect the front diff and the transfer case where you're most likely to smash something on a rough road. The skidplates aren't like full belly armor you might find on a serious rock crawler, but they're strong enough to keep you from splitting your transfer case if you misjudge the size of a rock in a dirt road.
The transfer case does have low range - however if you have the auto transfer case it's less robust than the part time transfer case. The anti-spin rear axle does work very well with the traction control, in particular 2013 and later trucks that also feature the same BLD function that Jeeps have.
Here is a video that demonstrates BLD on a Wrangler.
I've never had difficulty finding traction unless I was buried to the frame in snow and there was just no Earth to put a tire on. Sometimes it's necessary to turn off traction control to make the truck permit a little wheelspin, other times it works better to leave that enabled and let the truck find its way. It's good to be able to switch back and forth to find the right result.
The two largest handicaps I've found are the truck's size and its approach angle with the stock bumper. I lifted mine a minimal amount and put a high clearance bumper on it to solve those problems, now the only real handicap is the truck is too large for many jeep trails. I have no doubt it could successfully navigate a lot of them but only if I had complete disregard for the body.