The short answer here is that there isn't any one perfect time. You can mostly guarantee that there will always be great VPN deals available all year round.
Yes, most providers have now caught the Black Friday bug, and so there tend to be some eye-catching prices around November and December. But the likes of NordVPN, Surfshark, and PIA frequently have discounts here and extra free months of use there.