There are already many threads about this, not only here. In regard of what companies advertised their products as successor you'll find this yourself. Your decision depends on so many factors and your outset, that you can't really expect a recommendation. If you have a more concrete question, that would be fine.
The support situation surely is not the problem. Looking back at how many Foxpro applications still run in even older versions out of support longer, you can see that. But like any tool not enhanced you will get outdated sooner or later and get difficulties with interop.
I'm not that near to retirement to stay. A customer of us is migrating with their 20+ applications landscape to a standard ERP system, while their initial intent was to use best of breed software for the several portions of their ERP system. So we have an enterprise company as customer, a so called blue chip in the german DAX stock index, but you know yourself what range of software you can do with VFP, especially, if your customers care more about performance than user interface. I don't see anything replacing textboxes even in hundred years. You don't need many things for business applications.
Since we don't know what you'e doing with FoxPro and some key figures like number of users, database size and purpose/business it's hardly helping you, if I recommend something like SAP, does it? I can only say I'll leave and do something completely different. Since I don't own any product I'll offer my services, surely for anything on the topic of VFP, especially migrating applications and data. I'm more specialised on backend design and data migrations and API, than I am a frontend developer, a web designer or user experience (UX) expert, but I surely also gained enough project management and consulting skills to do small projects alone and cooperate with freelancers in larger projects. The split up with that customer is even more welcome than they think and I'll most probably quit before they'd like.
It doesn't have to be VFP for me, I can also implement and operate most any other databases and develop in PHP, HTML, Javascript. I don't need a VFP successor to get happy.
Bye, Olaf.