I'm a professional PHP, Python and Javascript developer from the UK. I've worked with Django, Laravel, and React, among others. I also maintain a legacy Zend 1 application.
I think that to a certain extent the whole meta tables thing that Wordpress does is now potentially problematic.
At the time Wordpress first came about, it made sense, because it was the only way you could easily store arbitrary keys and values about an object.
Now, however, most relational databases support some sort of JSON field which allows for storing and querying that sort of data. However it's difficult to imagine how Wordpress could adopt that without disrupting existing sites.
I think that to a certain extent the whole meta tables thing that Wordpress does is now potentially problematic.
At the time Wordpress first came about, it made sense, because it was the only way you could easily store arbitrary keys and values about an object.
Now, however, most relational databases support some sort of JSON field which allows for storing and querying that sort of data. However it's difficult to imagine how Wordpress could adopt that without disrupting existing sites.
I love how you think Wordpress/Drupal is.
Plus, any structural change made in Wordpress/Drupal mostly stored in database, and it will be hard to track when someone else new to the project.