Same setup as you, fan and NVMe and I can play 720-1080p video without any issues from all of the streaming platforms I've tried so far as well as local files. Also streaming 1080p 60Hz gameplay from my gaming setup over LAN with no problems.

Yeah, all I could find was vague statements about the DNS server lookup order being "OS specific" and windows specifically being know for "not respecting DNS order", see https://www.reddit.com/r/networking/comments/kb8hvt/dhcp_dns_server_order/

This is also supported by statements from pihole devs: https://www.reddit.com/r/pihole/comments/x2248t/is_it_worth_creating_a_second_pihole_dns_server/ And: https://discourse.pi-hole.net/t/primary-vs-secondary-dns/1536/4

And then there are the hundreds of similar questions which one could take as "evidence by quantity" or whatever.

Right, we are on the same page but from experience, setting DNS 1 to the pihole and DNS 2 to for example 8.8.8.8 in your DHCP router will make the pihole useless. There are dozens of similar threads across different forums saying the same thing but if you know how to do it please let me know... Example: https://www.reddit.com/r/pihole/comments/864oli/secondary_dns_setting/

Care to elaborate? Last time I tried to set the secondary DNS as backup while keeping the pihole filtrering there was no real way to do it without having two piholes. Even the pihole developers said as much

Setting a second DNS in your router will bypass the pihole though, making it useless unless both servers point to a different pihole server

If I had to guess I'd say because "an unknown man" can be intepreted as "an average man" which obviously is going to hit a lot of people.

The actual statistics of man vs bear is not really the point through, and a large number people did not get that. It's just that the question was phrased (intentionally or unintentionally) in a way that lends itself to this comparison.

The sony CD rootkit comes to mind https://en.m.wikipedia.org/wiki/Sony_BMG_copy_protection_rootkit_scandal