Sheet name vs sheet index.
The very old bug tdf#94975 shown in the subject got a new comment trying to change the perspective to get a possibly more inspiring view.
even older …
Get sheet names as a list - #11 by Lupp
and older
How do I access the current sheet name in formula (to use in INDIRECT) - #3 by JohnSUN
…
not sure it’s just a matter of perspective 
to package a/your solution, you could :
- submit a patch to Misc.xba (revision bf38dd800e6e4e820a0cef84e082d9bcee8e8133) - OpenGrok cross reference for /core/wizards/source/tools/Misc.xba
- submit a patch to LibreMacro - Macros for LibreOffice Calc » Libreoffice Extensions, or create your own extension
- clarify real-world use cases : Welcome to the Design and User Experience team - The Document Foundation Wiki
- map to existing XL feature : 150900 – (Missed-Excel-Functions) [META] Missed Excel Functions
…
If something is seen as possibly inspiring is a matter of perspective.
If a current state is consistent may be a matter of debate. But there must be reasons for a position.
My mentioned comment on the bug stressed consistency.