Welcome (hopefully) to the darkside @Edan_Ben-Atar and team of 6 (5 if that 6 included you lol) 
or as some people like to put it Notion’s Ugly Cousin 
you have hit the nail on the head! here we value function over form. tho there are ways to transform your doc into a Cinderalla (Codarella?) haha (search this community forumn and there’s lots of UI/UX examples shared by very smart people round here)
jokes aside, some tips in building out your doc from Notion -
- as @Piet_Strydom says, take a look at packs. Depending on your company’s techstack, you may be able to cut out some or majority of your Make automations. Also packs are generally more stable and less prone to break than external automations.
- Propounding on above, really look into Buttons. For me, this is the chef’s kiss of Coda. and youll also may be able to minimize external automations e.g. Make.
- Permission controls - Please be aware there are limitations to this on Coda currently. Look into/research what youre trying to acheive and if stuck, it may be helpful to create another post to clarify what can/cant be done?
With regards to AI and the pricing - if youre not familiar on the Coda lore - allow me to get you up to speed LOL
Coda officially merged with grammarly last month. they had a year review/product discussion a week ago, in it they discussed better permission controls (and also pricing).
you can watch it here: https://www.youtube.com/watch?v=IrCxgdGlq-k
summary post of it here: Big news: Grammarly is acquiring Coda! - #178 by Melanie_Teh
lastly, its not all rainbows and unicorns here in codaverse, like any other product, there are some downsides (mobile, performance, ui/ux, sharing). in the event (above) last week, they did address these issues. Cant speak for everyone, but general consensus is for now, we are cautiously optimistic they deliver on their promises.
But overall the ceiling is very high with coda, it does a lot more things right (than most SaaS out there. personally when i discovered it coming from Airtable- i thought WOW! this is a sleeper hit!).
anyhoos, hope this essay helps you and your team in making a better/informed decision to transitioning over and also feel confident in said decision 
Cheers!
Mel
p.s. not notion bashing either (for me thats airtable’s job lol) but cant deny i wasnt like that michael jackson meme eating popcorn when this video came out https://www.youtube.com/watch?v=ERarYs2KVPI and then this creator jumped on the train the next day, https://www.youtube.com/watch?v=N72GUFChW7A