Most of this topic comes down to one question: do you need a marketing leader, and if so, at what size.
The answers on offer are a full-time CMO, a VP of marketing, a fractional or part-time one, a consultant, or an agency. They are genuinely different jobs, and the titles get used interchangeably by the people selling one of them.
Before the individual posts, read the guide. The B2B Founder's Fractional CMO Guide covers what the role actually does, when it is the right call, when it is not, and how to tell whether you are renting a growth function you should be building. It is the most complete and most current thing here, and the posts below it predate it.
After that, the comparisons are useful for specifics. What separates a CMO from a VP of marketing, what a part-time CMO can and cannot do, the skills to insist on, and what a consultant adds that a hire does not.
One thing worth saying plainly: a fractional leader is not a cheaper CMO. It is a different arrangement with different limits, and the founders who get value from it are the ones who know which of the two they are buying.