A friend works for a major airline. They have an escape simulator. We went in after hours one night and tried it.
That particular style was a canvas tube that unrolled from the door to the ground. It had inflatable supports so it hit the ground at about a 45 degree angle.
Apparently it is traditional to NOT warn victims that it does not work like they might assume. Ahem. It looks like you'd slide down the tube and then contact the floor at a modest speed, like a children's playground slide.
But the tube is flexible, so you fall about 20 feet straight down, hit a sharp corner, and then get ejected onto the (not moving) floor at about 75 miles per hour. Well, it felt like that, anyway. I'd wondered what all the karate mats at the end of the slide were for... "tuck and tumble" is your friend on the escape chute.
I've only once witnessed a slide deployment (not in an emergency, I hasten to add) and it was pretty spectacular.
The CAA had decided that they wanted to see the TriStar slide being deployed, so we positioned an aircraft in the hangar in front of the assembled audience.
The TriStar was unusual in that the doors didn't open outwards, but retracted upwards into the roof space, fairly sedately under the power of an electric motor. But in an emergency (which might involve a complete loss of electrical power) there was also a humungous (15,000 lb) clockwork spring that drove the door upwards into its stowage in an instant, accompanied by a tremendous bang.
Normally, the slide pack stays attached to the door when it opens, but in an emergency (with no "disengage slides" call), it remains attached to the door sill and, once the door itself is out of the way, the nitrogen bottle inflates the slide and it falls into position.
Sadly, the CAA requirement didn't include having people descending on the slide, so mine and my colleagues' offers to demonstrate were politely declined. Possibly not a bad thing, given that a slide evacuations from a widebody aircraft will typically result in some injuries - mostly minor one like grazes or friction burns, but also the occasional broken leg.