Thank you all for your efforts to help me!
The problem has been found and fixed! The fact that the SATA device was reconfigured in the middle of the night was indeed a critical clue. Here's what Gemini said when given that information:
**********************************
What Caused the Device to Reconfigure?
A "Device configured" event indicates that Windows re-indexed or replaced the driver settings for your storage controller. Common causes at 1:24 AM include:
• Background Windows Update: Windows downloaded and installed an automatic background driver update or quality patch overnight, replacing or refreshing your AHCI driver INF file (oem157.inf).
• Power State Reset / Fast Startup Crash: If the system attempted an automated sleep transition or background wake (like a scheduled maintenance task), the storage controller failed to wake cleanly, forcing Windows to re-initialize and "reconfigure" the controller interface upon startup.
Is This the Cause of the Drive Disappearing?
Yes, very likely.
Looking at your screenshot, your storage controller is using an Intel C600+/C220+ series chipset driver from 2017 (Driver Version 5.3.0.1388).
• The Problem: Legacy Intel RSTe (Rapid Storage Technology enterprise) drivers from 2017 were designed for older Windows releases (Windows 7/10) and often exhibit severe power-state bugs in modern Windows 11 updates. When Windows 11 toggles power management states (sleep/wake), this legacy driver fails to send the proper "wake" command to the SATA ports, leaving the secondary drive unpowered until a manual rescan forces a bus query.
How to Fix It
Option A: Switch to the Native Microsoft Standard AHCI Driver (Recommended)
The built-in Microsoft driver is fully compliant with modern Windows 11 sleep/wake cycles and avoids legacy Intel driver bugs.
**********************************
When I replaced the Intel driver with the Standard SATA AHCI Controller driver (found on my computer) the problem went away!