Hello @Beelzebub-Crump Welcome to forums!
Here are two tutorials that might help you achieve what you’re trying to do:
Freeform Wall Run Tutorial
In this first tutorial, all you need to do is avoid connecting the Off Wall pin (18:30) and skip the steps from 23:40 to 30:00. With those changes, the system should work just like in the reference video you shared, staying attached to walls or ceilings without detaching unless you decide to.
Unreal Spider Movement
And in this second one, it’s much closer to what you’re looking for, and the character is very similar to the one in the reference video
If you have any questions, feel free to ask on the forum!
Hope it helps!