I'm using it, for VN development it is as "TrickWithAKnife" said, extreme overkill. There's only one feature you even need in there for VN design and that is the "flow" part of it, i'm sure you can find another program to do that somewhere.
Articy Draft 2 is even more overkill, i'm using the SE version, i see very few reasons to want to upgrade to articy draft 2.
Also the devs don't mind if you use the non-commercial version for a commercial product at least as long as it takes you to get enough revenue to pay for a license (which would be kind of you to do)
It's a common misunderstanding though that this tool is mostly just for big teams, it isn't just for big teams and i am currently using it alone. Sure it's convenient for multiple users, but in the end you only need the designer himself (or the designers of the team) to have access to the program, the data can be exported to word or XML documents to share with the rest of the team, this programs first and foremost job is to maximize the productivity and "precision" for the designer, and make the overall design process easier.
But i am using it for an RPG/VN, it's very helpful for that, even if theres going to be a while until i make the "big rpg" the software is perfect for making the universe it happens in (locations, characters, races, classes, stats, quests/stories/adventures(this is basically like a whole VN all in one feature called "Flow"), items... it keeps everything in one place and easy to read.)
To be honest there are various other good reasons to use the software, one is the color scheme. From a psychological view point their color scheme (the mix of green and yellow) should help increase our focus and attention, and again from a psychological perspective, working with colors rather than black on white makes it both more enjoyable and memorable.
The software is top notch and many huge game companies are actually using it (the likes of Ubisoft, EA and Cloud Imperium Games), but overkill just for a standard VN unless you really want to get that precision from using it as a planning tool to design your characters and keep track of the flow of the story. Here a
writer even recommends it.
In all cases where there's more to your game than just the story, i would recommend it. Even if all there is to your game is writing a story, having a visual representation (such as linking together different parts of the story or branches) it will still be very helpful, but i'm not sure if it's worth the 100$ if all you're doing is writing a story. You should always just check out the 2 week trial and see how you like it, 2 weeks is more than enough time to get familiar with the program. It most likely (almost inevitably) will increase the quality of your final game.
But in the event that all there really is to your game is the story, you might want to use more specialized software (just for novel writing) to get it done. Check
this for example.