I’ve been running FreshRSS for several years now without any problems, but mine is running on a dedicated home server running other services too.
Your experience will depend on your RSS client. As others already mentioned, you will want to configure your client to only pull manually (usually on open only), otherwise it will keep throwing errors at you.
I am going to second the recommendation to get your hands on a cheap Raspberry Pi (you can easily run it on a Zero 2 W) with an 8GB microSD. You can then get a cheap US$2/year domain and use Cloudflare Tunnel to access it from anywhere without having to open ports or expose your whole network to the internet.
The full setup should be around $50 including the Pi, case, microSD, cable, power adapter, and cheap domain in NameCheap or similar.
This is not strictly a self hosting answer, but given the problem you are describing, I think it is still relevant.
If you are already comfortable using an LLM based tool to manage email, take a look at SaneBox (this is not an LLM).
It is not an email provider and not an email client. It sits behind the scenes and works with almost any provider that supports IMAP, including custom domains. All the filtering, prioritization, and notification cleanup happens server side, so you keep your existing setup.
It excels specifically at what you are struggling with: automatically separating real human email from receipts, shipping notices, one time codes, and low value notifications, without forcing you into Inbox Zero workflows or Gmail specific features.