So, speaking about Beyond the Wall - where the roll-to-cast cantrips comes from - you need to see the context…
Cantrips in BtW are potent - they include things that, to borrow some 5e terms resemble Speak with Animals, Bless, Bane, Silent Image, Plant Growth, seeing & commanding spirits, etc. Most of them have more narrative weight & impact than 5e cantrips.
BtW divides magic into Cantrips (roll-to-cast and lose access to that cantrip if fail), Spells (you can cast a #=level each day), and Rituals (which are where the “at-will” magic happens but it’s longer casting, more requirements).
So within that framework, the roll-to-cast cantrips make a lot of sense.
In 5e RAW limiting cantrips is less a matter of systems/framework integration and more personal tastes. I haven’t get the need to limit them in 5e, but I get why aesthetically folks would be opposed to unlimited cantrips.