Character Walk on a Wall? (E.g Sonic running around a loop)

Add Force is pretty weak. An impact normal is a normalized vector, meaning it has a length of one.

My character is about the same size as the stock third-person character, and my dashing movement uses an Add Force of like 800,000.

The stock UE4 gravity force is -980 units per second. Start by multiplying your impact normal (using vector*float) by -980 and go from there