Rotate the player character based on speed

Hello,

I am setting up a character that is a ball, it can shoot stuff (like a vampire survivor style) and the character is a ball, so I want to rotate the mesh only (not the whole char with their weapon slots and stuff)

I watched many guides but it either rotates my whole char or use physics which is something I do not want to use.

I have seen local rotation and all but even applied to the mesh only feels cluncky and does not seem to work.

Any tips / ideas?
Thanks!