Visual Studio 2019 for Mac

They have ported their CLR, it's called .Net Core. If you need the legacy .Net Framework on macOS, Linux and the like, you still need Mono,which is not bad at all. It powered Xamarin and Unity for years.

"Xamarin Studio" was the IDE worked on by Xamarin (which was bought by MS. (IIRC itself was a fork of SharpDevelop). Since then, there's been a lot of work in rebranding and improving the UX, I don't want to understate that. It runs under mono for Mac, but can develop projects targeting mono as a Framework option as well as .Net Core, which is a ground up re-implementation of .Net itself that is cross-platform from the start and well supported.

My complaints are mainly that it was painful to install (unsure of current version), and in the end missing a couple of features that I needed and fallback to windows currently.

Microsoft database projects are a project type that does builds against an MS-SQL database and afaik can only be built on windows (even though SQL's core runs well with windows/docker).

TFSVC is the TFS Version Control system that TFS uses, not to be confused with Git, which is now the preferred version control for most using TFS (and Azure DevOps). TFSVC is similar to SVN for practical comparisons. However, the tooling outside of windows kind of sucks, and there is no support for this version control system in VS for Mac. The eclipse plugin for TFSVC is probably the best option for a decent GUI surrounding the version control system.