Can you try the following command from your computer:
curl -vk --resolve www.example.com:80:192.0.2.127; http://www.example.com
with your domain name and 192.0.2.127 with the IP address of your server).
If you haven't got access to curl on your computer (say you are running Windows without having WSL2 setup with a local Linux install), running it on the server should be okay.
That'll emulate - to a degree - what Cloudlfare is trying to do when it fetches the page from your site. If you notice it timing out, the problem is 100% on the "server side" (it could be an Apache redirect looping, it could be a long running PHP script etc: just as the Cloudflare resolution bit says). If it works quickly and returns the correct page, then the problem is most likely somewhere between Cloudflare and your site (perhaps the server firewall is blocking their IP address? - it'll be worth
ing the Apache/Nginx logs and the var/log/messages file when you make the request through Cloudflare to see if anything is being triggered.