XLM, or, Why won't MSFT provide useful information functions?

This will start off as a rant. Excel still has a Transition formula evaluation setting even though the IBM ceased selling Lotus 1-2-3 more than a decade and a half ago. Nothing other than MSFT's indifference or laziness precludes a setting for Traditional formula evaluation. What would I add which was nontraditional? Damn near everything Lotus Development Corp added to 1-2-3's @CELL function in Release 3 in 1989. 3 decades ago it was possible to get another cell's formula using @CELL("formula",X99). It took MSFT more than 2 decades to add FORMULATEXT.

Why FORMULATEXT when there was a perfectly useful GET.CELL(6,...)?

One of my greater frustrations with MSFT and Excel is MSFT continuing refusal to make all XLM information functions usable in standard worksheet cell formulas. OK, not all of them since CALLER would probably trigger circular recalc and LAST.ERROR would serve no purpose. However, I have a fair few workbooks which use names defined using GET.WORKBOOK(1,!$1:$1048576).

I dread MSFT deprecating XLM and thus removing its information functions.

Most of the XLM information functions' return values can be provided by VBA udf wrappers around certain object properties. However, VBA is much slower than XLM, especially for things like GET.WORKBOOK(1,!A1), which returns an array of all sheet names from the workbook which contains the !A1 reference, so the workbook containing the Name or Macro Sheet containing the formula calling that XLM function. In VBA, Excel's object model has a Sheets collection property for Workbook objects, but no direct access to sheet names. Thus, in VBA it's necessary to ReDim an array as return vlaue, iterate through the workbook's Sheets collection, storing all the sheet names in the array.

If we can use XLM information functions in defined names, and those defined names can be used in worksheet cell formulas, why can't XLM information functions be used directly in worksheet cells functions? TOO MANY FUNCTIONS was an argument which went out the window decades ago with the appearance of Bessel functions in Excel.