I hate to admit it, but I do work with Oracle Apex quite a bit. 15 years of experience to be precise. I've created several big applications with it which are running in production right now.
And still, if I had the choice I'd avoid it like the plague. This is 100% vendor lock in with very little benefit.
The only reason I'm using it is because it was already in use when I came into the picture and there was some know how in the team already. But guess what, those people left and now I'm the only one who really knows what's going on and has meaningful knowledge and experience in PLSQL, which you absolutely need if you want to create anything non trivial with Apex.
And of course finding people who actually know PLSQL at the level required to maintain those systems is very'hard. Who is going to learn an archaic procedural language which will only ever work within an Oracle database? Nobody within their right mind.
We tried introducing several rookies into this - all of them run away.
Another big reason to avoid it is that if you ever have the need to do something which is outside of what the generator accounts for, you will be fighting the framework constantly to still make it work and pray to the gods that no Apex update will break whatever you had to hack in.
There is really no reason any sane company should introduce this. It is not cheap. It is not easy outside of trivial things. The vendor lock in is huge.
Avoid!