Hey ,
Great question! Can you expand at all on the problems you face when running this function on tick? There is a great example of mouse behavior like this in one of the official content examples, specifically the Blueprints - Mouse Interaction level.
This is the relevant blueprint to make moving characters possible - note that this is in the actor being moved, not in the player controller.
I highly recommend poking through this content example. To access it, go to Unreal section of the Epic Games Launcher and click the Samples tab at the top. Then find the sample project called Content Examples and make a new project in the engine version of your choice. There are a ton of great examples in here!
I hope this information helps, and good luck!