How should I make the projectiles in a fps go straight to the middle of a screen? also, collision problems

I"m trying to make a FPS game using Unity Standard Assets, in which the user shoots arrows with a bow, requiring the arrows to be projectiles (contrary to a raycast-only fps).

I figured out how to make the arrows fire from a point of the bow and go straight somewhere, but what I actually want is making so that the arrows spawn from the bow and go to where the player is aiming (aka the middle of the screen).

I followed some similar questions here on Unity Answers, but for some reason the arrows don't go exactly to where the point is (they actually differ a lot from where the player is aiming). Additionally, sometimes projectile collisions won't register (the arrow sometimes passes through solid objects).

here is the code added code contained in the fps controller script that makes the player shoot arrows:

Ray ray = m_Camera.ViewportPointToRay(new Vector3(0.5F, 0.5F, 0)); RaycastHit hit; // Check whether your are pointing to something so as to adjust the direction Vector3 targetPoint; if (Physics.Raycast(ray, out hit)) targetPoint = hit.point; else targetPoint = ray.GetPoint(1000); // You may need to change this value according to your needs // Create the bullet and give it a velocity according to the target point computed before

                             GameObject arrowProjectile = Instantiate(m_ArrowPrefab, m_ArrowSpawn.position, m_ArrowPrefab.transform.rotation);
                             Quaternion rotationOffset = Quaternion.Euler(270f, 0f, 0f);
                             arrowProjectile.transform.rotation = m_Camera.transform.rotation * rotationOffset;
                             Rigidbody arrowRB = arrowProjectile.GetComponent<Rigidbody>();
                             m_ArrowList.Add(arrowProjectile);


                             arrowRB.velocity = (targetPoint - m_ArrowSpawn.transform.position).normalized * m_ShootForce;
                             //arrowRB.velocity = m_Camera.transform.forward * m_ShootForce;

                             UpdateArrowCount() // Checks if arrowList is full. If yes, destroy the oldest arrow object

and here is the code contained in a script attached to the arrow prefab:

 public class Arrow : MonoBehaviour
 {
     [SerializeField] private Rigidbody arrowRB;
     [SerializeField] private Collider arrowCollider;
     private bool hitSomething = false;
     Quaternion m_RotationOffset;
 
     void Start()
     {
         //arrowRB = GetComponent<Rigidbody>();
         m_RotationOffset = Quaternion.Euler(270f, 0f, 0f);
         transform.rotation = Quaternion.LookRotation(arrowRB.velocity) * m_RotationOffset;
     }
 
 
     void Update()
     {
         if (!hitSomething)
         {
             transform.rotation = Quaternion.LookRotation(arrowRB.velocity) * m_RotationOffset;
         }
         
     }
 
     private void OnCollisionEnter(Collision collision)
     {
 
         if (collision.gameObject.tag == "Player" || collision.gameObject.tag == "MainCamera")
         {
             Physics.IgnoreCollision(collision.collider, arrowCollider);
         }
         if (collision.collider.tag != "Arrow" && collision.collider.tag != "Player" && collision.collider.tag != "MainCamera")
         {
             hitSomething = true;
             arrowRB.constraints = RigidbodyConstraints.FreezeAll;
         }
         
     }
 }