The Arch wiki is my god. โค๏ธ
And yes, it's a rolling release model. I've not had issues with maintenance. I just install updates and go on with life. Sometimes the news page will have some notes about manual intervention that needs to happen but they are few and far between. Sometimes things that don't even apply to me due to not having the packages installed that have breaking changes.
I have two small kids and a full time job, I don't stress over maintenance one bit. I use it at work and at home, for leisure and gaming, as well as work from home and productivity, streaming, what have you. Just a normal OS, the only difference is the installation procedure, mostly. Now there's even a script that installs it for you, if your setup isn't too complicated.