> Is wordpress still the go to fool-proof CMS?

Yes. Wordpress is more customisable and extendable than the rest.

Squarespace, Webflow and Craft are either proprietary, have huge hype by newcomers (especially Webflow) or have missing features that make you want to go back to Wordpress.

I am sure that you can make a basic marketing site in either of these but you also mentioned 'CMS' and Wordpress is the easiest and the most extendable.