Welcome to the forum.
Arch is not designed to be a user-friendly distro, but a user-centric one. It’s designed to be simple to understand and easy to tweak and fix when something goes wrong. This is great, troubleshooting on Arch is a million times easier than on a more complicated distro, like 'Buntu. However, the price a newbie has to pay for this is lack of convenience that comes with a more automated, walled system like 'Buntu.
Arch has this reputation that it is only for nerds and advanced users. This is very far from truth, but it does require the user to have a DIY mindset and to be willing to tinker with his or her OS.
The bleeding edge is really not as sharp as some would have you believe. Arch stable is now well tested and breakages rarely occur, and when they do, it is typically the user’s fault and, the best of all, a user who is not completely oblivious is aware od that. Knowing that you did something to cause a breakage is not only empowering, putting you in control of your system, but it gives you a great starting point for troubleshooting.
When something breaks on a more complex system like 'Buntu (and do not confuse complexity of the system with the ease of use, it is typically true that more complex systems are more “user friendly”) you often don’t know what caused that breakage, because there are so many components of the system working behind your back and any of them could be responsible for the breakage. On an Arch system, you almost always know what you did to break it, if you are at all observant.
So, for a personal computer, I think Arch (and EndeavourOS) is a fantastic distro. It does require a bit more maintenance, but this maintenance is rather easy. The reward is that you get the freshest software that exists, which is also great for security of the system.
Regarding LTS vs Arch mainline kernel, why not install both? You can use the latest kernel, and always have the LTS as a fallback. Unless your hardware dictates that you use a specific version of the kernel, in which case you can find pretty much any version in the AUR.
Speaking of AUR, it is probably the greatest software collection in existence. You should not be afraid of using it (in fact, access to the AUR is one of the biggest reasons why anyone would use an Arch-based distro). Yes, AUR is a user repository to which anyone can upload packages, so you have to be careful of what you’re installing (check out my post about AUR security), but the Arch build system, which is behind the AUR, is fully transparent and you can know exactly what goes into which package (no trust is required, you can check everything yourself). This is much safer than PPAs or custom repos, or even downloading binary files from the net.