I can say this works in the narrow context as it was described, IF you remember to click on the shortcut BUT I am not sure this is going to work in cases where no Explorer windows/tabs are opened and you click upon something which results in Explorer loading, such as the downloads icon in most browsers which will open an instance of Explorer at the specific path where that browser is configured as its default downloads path.
So, this is more of a partial workaround rather than a complete fix. I am running Windows 11 Enterprise 23H2 for work and also have Dropbox, iCloud, and OneDrive adding their extensions onto the directory trees, as well as WSL2 running an Ubuntu 22.04 image. While I get that there are a lot more moving parts I have loaded which the file system has to deal with to mount these various services at certain virtual paths along the tree, this "Expand to Open Folder" is basic Explorer functionality which I believe has worked since Windows95, if not Windows for Workgroups 3.11, which is how long I have been running some flavor of Windows (>30 years), desktop and Server.
Any explanation that this is intended behavior, or even a deprecation of how this feature has formerly worked, is not going to be met with anything other than contempt as the options are very clearly in the same place they have been for decades and they just no longer work as intended without going through one of the community-offered workarounds, of those which actually even work for any other than the one who posted those (appreciated as these contributions are, they are not universally applicable). I suppose the next logical step I could take would be to replace all instances in settings which result in Explorer launching instead with my new shortcut to Explorer with the %userprofile% argument which I created on my desktop, although I am NOT doing that as it seems like an even greater opportunity for me to break so much more functionality that I don't as readily understand.