The new url for mirror manager is: https://mirrormanager.fedoraproject.org/
This post describes how to modify the repository files:
You could try static urls in various locations to see if it improves.
After searching about it online, I found that this was actually a very common issue, but a lot of people said that it was fixed with DNF 5, which comes by default with Fedora 41 that I installed
dnf5 did improve processing speed, but the mirror and your bandwitdth are going to determine the download speed.
Welcome to 