I'm not sure what you mean by "complex ODBC" since ODBC is not used in Drupal. The opposite of what you were rooting for is for the end-user to have less power and the coder more power. Get this, Drupal is not taking that power away from you, it is giving some of it to the end-user. It is 2014 and there are still products out there that you have to modify using in-line code in order to get a simple feature such as hiding the author of a post. This is where Drupal gets it right, by letting the end user have more power, they get the site they want, not the site that a coder hands them. Don't like the way posts are displayed on the home page, then create a new view in a UI, not in a php while loop.
There are some beautiful things in Drupal and Drupal 8 is going to be even better. Drupal is an excellent example of software getting better by rebuilding, using best practices rather than just keeping cruft from 10 years ago.
The bottom line for us was that the compromise Drupal was offering (you can semi-code in the UI, but still need to rely on some custom coding for some glue) wasn't serving us well anymore. The Developer Experience was getting worse at each iteration.
I also don't feel it was ultimately serving our customers; most features are overwhelming, and it usually took a lot of training on our end to make the end-user not too unhappy.
A good deal of the really innovative folks have left the Drupal island.
Unless the pool of innovative folks is stagnate this doesn't make any sense.
What I mean is that at this stage, the direction of the project is pretty much set, and there's not a lot of effective pull made in other directions. A lot of the folks who were bringing some balance have simply left.
There are indeed still tremendously smart and innovative folks in this community. Not a lot of people questioning what "the Drupal way" should be though.