This was extremely disruptive as the only solution was to reboot the PC until I discovered a workaround. Running the AMD autodetect drivers application seems to force the system to detect the missing drive and reinitialize it. It otherwise doesn't appear in windows explorer or the disk management tool whatsoever, but once the driver utility scans my hardware, the drive pops up as connected and functions completely normally. I've reseated it multiple times but the issue persists.
Ideally, I'd like to avoid this problem altogether, so I'm posting here to see if anyone has a similar problem or has a better solution.
Specs:
Motherboard: Asus x670e-e strix gaming wifi w/ 2403 (latest) BIOS and latest chipset drivers
CPU: Ryzen 7950x3d
Ram: G.Skill Flare X 2x32GB DDR5-6000
GPU: ASUS Nvidia RTX 4080
Storage: 2x Samsung 980 PRO 2TB m.2 SSDs in slots m2_1 (this is the one that frequently disappears) and m2_3 (OS Drive), 2x 870 EVO 4TB SATA SSDs, 2x Seagate IronWolf 8TB HDDs
PSU: Corsair RM850x