Why are you worried about your site going down during traffic surge? Unless you’re running a critical service, there is no need to worry about this too much if it’s just your personal sites.
Because it’s an important business website that would have severe consequences if it went down during traffic spikes (which it does get).
With proper caching, your personal site can even tank traffics from reddit frontpage on a $5/mo vps.
Yeah, I’m using Cloudflare, and I saw that Wordpress has a built-in caching option, but I couldn’t find any info on how well that protects sites from traffic surges.
consider hosting it on platforms with autoscaling support such as netlify.
Yeah but I need an SSG with the same capabilities as Squarespace to do that, and as mentioned in the OP, that doesn’t seem to exist.