I think you can try your luck with either Nobara or Bazzite, they are very user-friendly. I find Nobara more user-friendly, but Bazzite is an immutable distro, so it is naturally more stable, more secure, etc.
I use Nobara KDE, and the idle RAM consumption is of around 1 GB.
You’re not alone in this, those kinds of things are hilarious, but also alarming, lol