Thanks for both your responses - @chatouille I tried following your setup but unfortunately it seems to only make a very slight rotation to the cursor in my case.. would you mind showing the results that gave you?
@Shmoopy1701 Yes exactly, would I be able to construct that spline based on the position of my character/camera so that it the normal would adjust in that direction?
I realised part of the issue is that the normal is always constructed perpendicular to the hit normal, so by slightly offsetting the hit location, I was able to orient the cursor to my liking.. now I’m just trying to figure out how to adjust this offset so it’s driven from the vector between my hit location and the location of my character/camera?