So I installed the locks and did rough measurements. Front door is about 15 ft from the Apple TV and the back door about 26 ft away. Tested the following with Siri (all without the Connect set up and with wifi/Bluetooth on and then off):
In the living room, worked.
In bed, worked.
In my garage, worked.
At the back of my backyard, worked.
I tried asking lock status of each door, then for both at the same time, as well as locking/unlocking each and both. So, for me, either my phone or my Apple TV is close enough to reach either lock.
I also turned wifi/Bluetooth off and tried operating the locks using the Home app. Works... It shows the locks' status as well as operating them.
I know what you mean about all the separate apps.. I just tuck them into a smart home folder. I usually operate them via widgets, or Siri. Our lights we have scheduled and will rarely operate them differently. When we do, we just use the physical switches.
Also, to clarify my "bedtime" scene, it's not a HomeKit scene. It's an "activity" that I have set up on my Harmony remote, like "watch tv" or "play Xbox". It's so when when we're turning in for the night, I press the "bedtime" button on the remote and it shuts off the tv, amp, turns off the lights (non-HomeKit Insteon switches and HomeKit hues), and locks the doors. It's not related to HomeKit/Siri so it requires the Connect to access the locks.