So, it might not sound like much, but 4gb of ram is plenty enough to do quite a bit with self hosting.
If you want to self host, and use it as an opportunity to learn, I recommend you install Debian, and get your hands dirty. If just want to self host without much of a headache, yunohost seems cool, but I’ve never used it, so I can’t recommend it.
It’s a shame Majaro of all distros have a good outreach to companies. I wish better distros had the outreach and connections they do.