VS Code is a great text editor for me. I write Markdown documents, manipulate bulk strings, and diff files with it. Aside from small scratch projects, its consistency and reliability as an IDE is varied for me. It's far from "just works", at least for the types of things I do (C, C++, C#, Rust) and isn't really on my list of editors I'd recommend for those workloads.
You can make it work, but it's going to require extensive time spent figuring out what extensions to use (and their quirks), ensure that you have a working setup to the language server, and learn how each environment wants you to setup its tasks and launch configurations, if applicable. Unlike larger IDEs like VS or Rider, it doesn't have a consistent "new project" process either, so you're on your own for that.
An extension called Indie Wiki Buddy can also help with this by helping direct you to known alternatives to fandom for specific franchises or falling back to Breezewiki-based instances that rehost Fandom content without all of the Fandom bloat. It also provides this filtering and hinting to search results too, so you don't have to change your workflow too much to use it.