For new formulas, yeah, It's hard to input new formulas, even in spreadsheet. The system is somehow complex, you probably need a UI for new formulas too, even if it's in spreadsheet.
The reputation of user unfriendliness is undue, and based mostly on looking at how pros work with it.