Here's one from my neck of the woods...
https://www.google.com/maps/place/Chillicothe,+TX+79225/@34.2626128,-99.518236,1233m/data=!3m1!1e3!4m2!3m1!1s0x87ab49b1ec5da867:0x685ba35a60a985bbThis one has ultimate flexibility in that it can receive a train from either direction and return it to either direction. But like Rick said, you could either do a straight track, or with the covered loadout in your video it could go into a backdrop and then either loop it behind the scenes, or have hidden stub end tracks to hold the entire train. One idea there is to have an identical train waiting with an identical "loaded" train waiting to pull out as soon as the original cleared the switch. This would give the impression of it looping and coming back through without needing a lot of real estate. It would require some rolling stock though.
I've also seen them as loops...not reverse loops but full circles...that would either send the train continuing in its existing direction or require a runaround move or DPU setup. And of course the wye in the photo above isn't really necessary.
In some scenarios with my dream layout planning I would model the above setup. There is also a power plant nearby so I was thinking of maybe doing a backdrop feed for both and having a loop underneath somewhere that could serve both. (perhaps not at the same time but even that wouldn't be impossible.)