I'm feeling your defensive feelings for linux lol. I am pro linux. I love open source, private, non-corporate, stable, software. The community has been fairly supportive in my experience. I use it daily on my pi-hole, and HTPC.
My "advanced needs" comment was in comparison to your "tech illiterate wife" and "80+ year old grandparents" comment. I felt your comment was condescending, as if to say it's so easy to use, anyone could do it. Well as I commented earlier, that may be true based on your needs. My kids used it but their experiences were limited to the browser and zoom.
I've attempted several times over the years to switch to it as a daily driver, but never stick, because my "advanced needs" are essentially any computing interest i may have, whether gaming, programming, running local AI, or just setting up my OS the way i like it. You could argue linux can do each of those, but in my personal experience, Windows does it easily and smoothly every single time. The effort of getting Linux to run the way I want, and smoothly, is not worth the benefits to me.
That being said, i am PRO Linux. It's just not for me, right now as a daily driver. I really really really want that to change in the future. Hell i'm dual booting right now, i just never select it anymore.