The v1.2.4 release might fix up some of your issues:

This release adds TCP fallback to the DNS stub resolver, fixing the longstanding inability to query large DNS records and incompatibility with recursive nameservers that don’t give partial results in truncated UDP responses. It also makes a number of other bug fixes and improvements in DNS and related functionality, including making both the modern and legacy API results differentiate between NODATA and NxDomain conditions so that the caller can handle them differently.

Not that it matters much if you’ve already migrated away to a libc distribution.

migadu has been pretty solid the last few years and they’ve got some great pricing on plans that’ll be sufficient to host an entire family.

Solidigm (ex-Intel) apparently has a P41 Plus 2230 1TB model that’s decent (p/n: SSDPFPNU010TZ01).