I'll introduce you to the concept of WAF, Wife Acceptance Factor.
Basically, all smart IoT devices MUST default back to dumb behaviour in an expected manner. All MITM systems must either fail gracefully, fall back simply, or be robust enough to not fall over.
Get yourself a partner(s) who know a thing or two about tech and can at least perform basic troubleshooting and report to you.
Huge, thick cock but tiny brain and reeeeeeeeee? Pass. Small cock but can tell me when my homelab goes down, what services are actually affected, and suggest a solution that is plausible and is for up-to-date versions of X? Call in pizza and ice cream and clear your schedule, it's sexy time. And they knew a temporary solution for the outage so they aren't impacted while I was busy/away? Marry me.
There's a lot of other factors but that defo plays a factor. Learn tech, get blowjobs. It's that simple.
First of all, my parents have a Raspberry Pi V1.0 (the still holeless one) that has been piholing since day one. That's like a decade.
I keept it there, caseless and dangling from the lan cable, for sentimental reasons, I've grown fond of it.
Second of all, there is a secondary dns on Proxmox should the Pi need a rest.
Edit:
Forgot the third of all - that Raspberry doesn't even have a heatsink, much less a fan.
It's called a secondary DNS server. Like, literally the reason it exists. I guess it's still on the line towards knowing what TF you're doing.
Every DHCP server offers at least 2 dns server options.
This is a mistake you only make once, which is why I now have a dedicated dmz network for work equipment that doesn't use the pihole for DNS resolution.
Full arr stack makes life much easier. Only time I got that look was when it pulls a .rar that didn't automatically extract. Wrote a script that transmission runs on completion and they extract when finished now.
Its a rookie mistake to implement a highly desirable, but low WAF (wife acceptance factor) solution to some shared resource.
The linked picture should have had a separate SSID that doesn't route through Pihole, so if the raspberry pie dies, wife know to simply change the SSID she connects to.