Attaching weapons to hand very tedious

Yes, although if you dont want to change your source asset another(slightly hacky) option would be to Add an offset and rotation to your mesh when interacting/attaching it.

Another good option would be to create custom socket inside of your Static Mesh (socket manager tab)