No. not in a genuinely competitive niche, and i dont believe most of the people saying yes either.
what usually happened in those stories is the site had links they didnt count as links. directory listings, a reddit thread, few social profiles, a mention somewhere passing something. thats still a profile, just an accidental one.
content only wins in niches where the competition also has nothing. soon as one competitor starts building content alone stops holding. been doing this for decades and never once seen a real money niche fall to content by itself.
good part is links stopped being the expensive bit. content used to cost more than the links lol, now its the other way round