I use it for Unity Development at home (C#). Also for any basic text files and ****** scripting work. Also sometimes use Notepad++.
For Unity the differences are massive it has all the support I need to do the work but starts up in a 10th of the time (compared to full fat visual studio) and has a much smaller running footprint.
At work I use if for everything on both linux and Mac. C/C++, Javascript, Fortran, Perl, Haskell, Prolog, HTML, ****** scripting.
An entire office full of people arguing about whether Vi, Vim or emacs is better and I have a full GUI, syntax highlighting, syntax completion, spell checker and remote debugging over SSH.
There is normally an extension out there to do what you need that you can access with a couple of key strokes.
Its new remote tools are amazing.
I have not had chance to try its collaboration tools but I have heard good things.
As above the only problems I have seen are when you try to open a massive file or a project containing LOTS of files.