That said, I just think rolling is superior and leads to more fun (all else being equal which it never is) and it definitely leads to more diverse builds because things are either possible or excluded based on your dice.
Right, my opinion is different.
For example with great rolls you can build the combo melee and missile Fighter who is not only good at both but excels at both, or even the mythical Fighter face.
These seem easy to do with 5e arrays or point buys.
Fighter who is good at melee and missile goes dex and con uses finesse weapons and dex ranged weapons. Or str and con and uses str thrown weapons.
Fighter face goes str, con, cha, takes a background with a social skill (probably persuasion) and is a decent face. The 15, 15, 15, 8, 8, 8 array seems built for it.
On the other side with poor rolls there are a lot of common themes that are not viable (and in some cases specific classes can't even be viable) - if you have 3 rolls below a 10 you need to have 3 dump stats and that locks out a lot of stuff. For example you can still play a very effective Wizard or Cleric with 3 low stats, but you can't really play an effective melee bladesinger or plate and shield melee cleric and even something common like a Rogue face is going to be difficult.
I mostly agree here, although I disagree on some specifics.
The more MAD a build is, the more low or mediocre rolls can hurt or the more lower point buy can hurt. Monks are a decent example.
I think a heavy armor melee cleric can dump int, dex, cha and be fine.
I think a face rogue is fine with dumped str, wis, and int. They will get by decently enough on perception and investigation with their skill proficiency(maybe even expertise) bonus.