I don't have a solution, but I will share my experiences with Charter/Spectrum.....
I've had their internet service for over 20 years. I don't use any Spectrum supplied devices however as I bought my own cable modem long ago (and I've upgraded it at least once during that time). While I'm sure at some point in the last 20 years there was a situation where I didn't have internet service and rebooting the cable modem "fixed" the problem, I honestly cannot recall having to do that. Certainly I have not had to do that recently. In other words, the chances of your internet outage being caused by a "stuck" cable modem is extremely low. In the same way, it is just as rare than any "internet" outage is actually caused by my network equipment. I do run a pfSense Firewall (along with enterprise quality network switches and wireless APs) which is a lot more robust than most residential grade all-in-one routers, so perhaps that helps my overall reliability.
To be honest, I don't notice very many internet outages in the first place - perhaps a couple times a year. However in 99.9999% of the cases, the internet come back online just fine whenever Spectrum fixes the problem on their end. Granted this may be why I don't notice very many outages (because we are not home during the weekday "work" hours usually), but if so that just proves that things tend to come back online automatically. Personally I wouldn't spend a lot of time or money trying to solve this "problem" because I don't think it will end up increasing the reliability of your system and will actually cause more harm than good by resetting equipment and causing downtime on your local network for no real benefit.
I guess this means I do have a "solution"...... If you find yourself having to reset or power cycle any part of your network in order to "restore" functionality on a regular basis - you need to replace that device with a higher quality device. That is not a "normal" behavior that you should just "live with" or feel compelled to find solutions to automate the power cycling process IMHO.
Edit - please note that "higher quality" does not necessarily have to be expensive. I spent less on all of my network gear than some of the "higher end" residential grade all-in-one routers that are being sold right now. ($150 on pfSense hardware (used on Ebay), $0 on pfSense software, $125 on enterprise grade 48 port POE switch (used on EBay), $115 for wireless AP = less than $400 total).
Edit - I remembered that I actually do have one piece of Spectrum hardware in my house - a cable card that I "rent" for $4/mo. I use it to be able to view/record cable TV across my entire house. I don't even have a single cable box in my entire house.