For all the use cases I can think of, git worktree could be used to simulate this without any fuse dependency.
Regardless, if you are asking whether you can check out commit that doesn't have a branch pointing at it, yes you can.
You can have a work tree for every commit in your repository if you like.