However Google sheets is nowhere the install base of excel, so this is a really big deal
(So no, Google Sheets does not support this)
The latest improvements in Excel really do seem to be re-widening the gap between Google Sheets and Excel (Dynamic array formulas, Let, Custom data types, powerquery improvements...)
I think Google Sheets has a pretty solid user base.
Highly anecdotal, but there are far more complex business processes still running in Excel that are not going to be translated over to Google sheets, and they are all offline behind a network firewall.
Those types of sheets will really benefit from this improvement.
Now if they just supported python instead of VBA for scripting!
And these are not for particularly complicated functions.
I'd really love to have this feature in Sheets. It would simplify a lot of what my sheets do, and also make it more accessible to a Sheets power user that gets scared off from code.