PikaOS maybe too “hobby oriented” to expect “sleep stability”, but I understand most/all bugs to be debian or kde upstream ones. Is gnome still much better at stability? Is there a distribution that fixed sleep problems for you? open vs closed nvidia drivers?
Are there motherboard manufacturers that suck less at linux?
System76, Framework, even Dell officially supports Ubuntu in limited cases.
I’d just try a couple different distros and see which one has the fewest issues for you. If you like, you can pay for official support from Dell or Canonical. If you do identify an issue in a supported scenario (Ubuntu version + device model) they will actually help you troubleshoot and resolve the issue. RHEL is the same if you want to pay a bit more.