[thedoops]

You're right. Salesforce is a big, complicated, multi-tenant, CRUD application coupled to an Oracle database. Multi tenant architectures themselves aren't an issue, but Salesforce implemented it well before the days of containers. All the Apex code has to be "bulkified" which means writing almost everything for multiple records in an execution context. This adds to the mental effort and reduces readability. A major concern when not all consultants do it well.

They've been trying for years to replace the Oracle database with Postgres, but it's not easy in such a large, heavily used enterprise application.

For many situations I recommend integrating with a messaging system and using the REST apis from something like Ruby.

Lightning is not bad, but it's slow compared to the front end framework competition. It is pretty fast to develop with though.