fix: pnpx context awareness + e2e tests

[mrstork]

Summary

• Follow up to fix: make cli aware when run in npx/pnpx context #7315
• unlink command output consistency
• Fix for pnpx command context

---

For us to review and ship your PR efficiently, please perform the following steps:

• Open a bug/issue before writing your code 🧑‍💻. This ensures we can discuss the changes and get feedback from everyone that should be involved. If you`re fixing a typo or something that`s on fire 🔥 (e.g. incident related), you can skip this step.
• Read the contribution guidelines 📖. This ensures your code follows our style guide and
  passes our tests.
• Update or add tests (if any source code was changed or added) 🧪
• Update or add documentation (if features were changed or added) 📝
• Make sure the status checks below are successful ✅

A picture of a cute animal (not mandatory, but encouraged)

[github-actions]

📊 Benchmark results

Comparing with 03fd72d

• Dependency count: 1,148 (no change)
• Package size: 271 MB (no change)
• Number of ts-expect-error directives: 397 (no change)

[serhalp]

🎉

[serhalp]

Nice approach you came up with! Just partitioning into two sets of table tests makes sense.