I took some time over past two days, and refreshed an old direnv extension for VSCode, merging one hanging pull request and rewriting some code.
Now it loads environment before starting other extensions (really useful for developing on Nix), and shows a nice status icon.
Updated version is already available at open-vsx extension market, or via Ctrl+P → ext install direnv.
Repo is available here
Your suggestions are welcome!