Melee combat without Animation

It depends on how you want to animate it.

If you are talking about the “pitch rotation only” kind of animation, you can try to use the “set actor rotation” node or “set relative rotation” on the y-axis of the sword. This setup is flexible, you can also try to combine the other 2 axes to make it more “realistic” or so.