The other way I look at it: TNG was following the premiere ship in the galaxy, with plenty of places to explore, so it was always encountering “new frontiers”.
The Orville on the other hand was more a premise of “what happens when space travel is commoditized and you have more than enough ships and now need competent bodies to staff it?” For that it feels more “real” that you’re getting people who do it as a job, not a calling, which explains the random humor and diversions and a look at new discoveries through fresh eyes rather than “wow, more new as this is normal for us”.
Depends on where/how it was installed. Code where I was at required a shut off right before it, independent of the bypass (and I almost called out the bypass on my original post to account for that)
Do you have a water softener? Usually that’s the first ingress point into your house, even before the hot water heater (normally). Most of those will have a shutoff value near it. It won’t get your outside faucets but at least it’ll get everything in your house.
Please keep forcing people back into the office. My company has embraced WFH and I got over 150 resumes for a senior position that was historically hard for me to fill given where we’re located. I had my pick of who to hire rather than being stuck with whoever was willing to move here.
Are you sure the pipe extending out of the faucet just isn’t stuck on there and can be removed? If so, just take it off and thread it back on to the wall and then you can use any normal faucet from HD. I have one similar to that when I was replacing my shower head and noticed it was getting stuck to the head rather than staying in the wall.