Is it a good idea to schedule a daily CHECKPOINT?
It's hard to know this for sure given the limited information here, but I don't think you're quite down to root cause yet.


Why did a huge spike in disk activity make you think the root cause was a checkpoint?
Why would the best fix be running a checkpoint manually?
Have you checked into which queries were running at the time, and what their wait stats were?


Checkpoints already happen much more frequently than daily - the default in 2016 is every minute.

So to answer the question:


Adding a daily checkpoint would be a bad idea and ineffective
Consider doing more troubleshooting like checking the server's wait stats
For a followup, include server config and wait stats info in your question (disclaimer: that's my blog post)