The vast majority of my open source projects, I’m the only user. I release it open source because back in the day, GitHub only allowed open source projects if you want to use it.
But another reason is the hope that someone will find it helpful. If not the project itself but maybe the code.
I have one project that has a significant following and honestly it’s sometimes very scary because I might not want to keep it updated because of my own interests changing.