Re: "many developers such as myself who are not writing off-the-shelf apps "
Delphi has had a messy history and plenty of missteps, but this comment is full of mistakes.
Starting with one of the most important ones first: 'The Pro only allows for local databases. You need the Enterprise to target RDBMS - even the "lower end" ones, as if only the larger companies still run them.'
This is categorically wrong. How do I know this? I've been using Delphi Pro to do MSSQL work for two decades. Typically, the Enterprise ones contain some proprietary DB connection components, but we've never used them. The ODBC, OLE DB and native SQL drivers have always been just fine for us, combined with the ADO components. I'm sure you don't love one or more parts of that, but it's definitely not true that you need anything but Pro. And if you did want to use the free edition, there are plenty of 3rd-party database components that will let you connect to whatever you want.
As far as them not changing SKUs in forever: again, you could not be more wrong. They changed SKUs back and forth left and right - too much, in my opinion. They were always trying new things. Their problem has always been that the number of users has done nothing but remain stable(ish) or gown down. They can't really offer a lower price and stay in business, because even if they priced their best product at $100, they'd never get enough users.
As far as Architect containing tools that change every year, that's definitely an exaggeration. Yes, they do change, but their main competition left is MS, and they're the king of flighty software. When I went to make the switch for new projects to Visual Studio/C#, I found that complete disarray of MS when it came to WinForms or WPF and Entity Framework, LINQ, and ADO.Net. It's just about impossible to even get MS to tell you which thing THEY want you to use and won't abandon next. Even before this round, we've all went through that with numerous MS Flavor of the Years. Yet we used Delphi and more or less ignored that. Delphi was way more reliable when it came to shifting technologies.
Finally, slightly pedantic, but you keep saying "Embarcadero." That makes me really not trust any of your observations. Embarcadero is a company that existed for 15 years before they bought CodeGear (then owners of Delphi) in 2008. And CodeGear was just a division of Borland that was spun off in 2006. Almost the entirety of Delphi not managing to keep its market share is on Borland's shoulders. So when you say "Embarcadero did this" or "Embarcadero did that", it makes me raise and eyebrow and question your credibility. It's like saying "Google created the first major video sharing platform" because Google later bought YouTube. Just doesn't make sense.