I was a climbing instructor and saw 8 year olds climb a 20 foot knotted rope pretty handily. In fact, anyone who isn’t totally overweight and in reasonable shape can climb a knotted rope at least 15 feet. A rope with no knots requires more hand and upper body strength...dc 10? 12? Depends how thick the rope is. Most adventurers of strength 8 and higher should be able to climb a knotted rope without much of a problem. I’d give it a dc if 5 which, incidentally, is the dc of the climbing a knotted rope in 3.5. I think, in 3.5, your rope lost half it’s length when it was knotted. Silk rope would probably lose less length because it’s probably more fine.
In that edition we used rope trick for lots of things because it lasted 1hr/level. By 4th, you could sleep half the night without fear of an encounter. It got used constantly for many many levels because we found ourselves in enemy territory quite a bit.
The 60 feet is handy if you want to access someplace high out of the way. Like scaling a 40 foot cliff is now a lot easier because you have a perfect anchor at the top of the cliff. No need to worry about grappling hooks or shoddy knots.
We gained entry to a place by having a pc distract some guards long enough for the rest to climb in to it. We came out later when the place was unguarded.
The short duration really limits its usefulness. You can use it to spy on a secret meeting, I suppose. If you can work out a way to cast it in the room ahead of time. And as long as the meeting is brief. The way they created Leomands Tiny Hut, rope trick is much more situational.
As an aside, instead of a rope ladder, just add loops tied with Prussik knots to the rope and use them as hand holds. You don’t lose any length to your rope and it is as effective as a ladder. For weak characters who might fail a dc 5 check in an emergency, add a foot loop at the end and have strong characters pull you up.