Seems like this is the best idea: to create a second library which contains all photos through 2023, which resides on external storage, which can be backed up when attached, and keeping photos from 2024 through present on my devices synced through to present, not optimized, and backed up full time.
The other option I discovered, but which requires more intervention, would be to make a second user, which maintains a non-optimized Photos library, which resides on an external drive. As long as this user is running and the external drive is attached, and included in my backup plan, it also works (as would buying a second computer to stay online and synced with full size iCloud Photos).
I think Richard’s solution is safer and more elegant, it just means I won’t be walking around with my entire library on my daily drivers. I can probably save some money on iCloud storage now as well. If I keep the external library on a network share, access ends up being as simple as changing libraries (connecting via VPN if not within said network).
Thanks for helping me sort through the options Richard.