I have used CyanogenMod a few years ago and it worked fine compared to the original Android that was installed. Never had any particular issue with it. But I think CM is dead now? And LineageOS is more or less its successor?
I have only tried LineageOS itself on SBCs rather than on mobile phones. IME, it worked but with various issues. It wasn't as good an experience as with CM, but then again, maybe it was mainly because I tested it on SBCs (which always have incomplete support, more or less) rather than on a phone or tablet. Otherwise, LineageOS seems to be well regarded, so I'm sure it's usable. Probably with various luck depending on the model.
There's a number of alternatives, such as Pixel Experience or SparkOS:
https://get.pixelexperience.org/https://spark-os.liveOf course you need to find one that supports your particular phone. And then you need to be able to unlock its bootloader, which on some of them is either nearly impossible, or pretty cumbersome.
Once you're past this and you follow the documented steps for installation, it should not be too much of a problem.
I have a Redmi Note Pro phone lying around that I plan on "recycling" using one of the two above - haven't gotten around to it yet. The annoying part with Xiaomi is that you need to register to be able to ask for a bootloader unlock, then you need to use a Windows app - that bites. But I'll probably give it a try, at least it's possible, while with some vendors, there's no way, or sometimes you have to solder wires on the motherboard and use some flashing tools.