I am not a mod author, so I can't comment on whether or not Vortex is awesome or terrible when it comes to creating mods. I just want to share my experience with and opinions on using Vortex as a mod user.
First, ignore my post count - I've never been very vocal on the forums, but I've been around this site and modding since it was TESSource and I discovered Morrowind. I've used all of the most popular mod managers and tools for Gamebryo and Non-Gamebryo games. I've used both manual and tool assisted load order management. I've learned what does and does not work when modding, quite often the hard way. I've spent days tracking down CTD issues, as well as done the whole "spend a week modding instead of playing" thing. I've created custom tools for my own use that parse plugin and save game files in C++ and C# and even made contributions to NMM. I've made countless merged / bashed / smashed patches. I'm definitely not a novice when it comes to modding.
I've been using Vortex since the alpha release, version 0.13.1 I believe, and have never thought about switching back to another manager. I found the workflow so similar to that of MO / MO2, even NMM, that I was able to jump in without watching any tutorial videos. It does what I need a mod manager need to do, and does so quickly and efficiently.
The automatic load order sorting hasn't failed me yet, nor have I needed to define any custom rules / groups. This is with currently 168 plugins in Skyrim SE and 88 plugins in Fallout 4. If load order issues were to arise, its nice knowing that there are tools I can use to "correct" the automatic load order. I really don't miss manual, drag-and-drop plugin load ordering. I used to spend hours trying to get the "correct" load order, but I simply haven't cared since I started using Vortex.
As for how Vortex installs mods, I personally feel the hardlink deployment is superior to the alternatives. It has the flexibility and power of the VFS from MO / MO2, without requiring you to run games and tools through Vortex or leave Vortex running. It's also really fast when it comes to deploying / purging. Want to change which files overwrite each other? Swap the order and redeploy - done in seconds. Decide you don't like that mod you just installed, but want to keep it around for a future character / playthrough? Deactivate it and redeploy - done in seconds. Have a couple of huge texture mods that you just can't seem to decide between? Activate one, deactivate the other, deploy and play - done in seconds. The only time you may need to reinstall a mod is if you chose the wrong options when installing, or need to choose a different set of options.
While MO / MO2 have effectively the same benefit, their disadvantage, to me, is that your modded game directory doesn't actually exist anywhere. It is dynamically created and only exists (in memory, not on disk) while MO / MO2 is running. You need to run the game and all tools through MO / MO2, which I found to sometimes cause issues and crashes.
TLDR; Vortex is awesome, the 1.0 release is well deserved (already installed it), looking forward to the features to come!