Thank you for the advice. The software I have used so far without success for various reasons like accuracy, quality degradation, crash with photos North of 800 etc was as follows: Microsoft Ice, Auto Stitch, Hugin, PhotoStitcher. I must confess that in some instances my skills might be lacking. Microsoft Ice is the easiest one for my to use, but lacks accuracy.
My use case is to merge 800+ 4k photos into one single large Arial photo that can be used to inspect roofs and other aspects of a property from above. Also many other uses like progress on development or agriculture planning.
I have used Metashape Standard for 3D models and I really like it, but I don't know if I can get a high detailed 2D Arial photo from it. If it is pos3, then I will really attempt doing it.