yes and no. Its a great Dr Jeckel and Mr. Hyde street to track option. That combined with the low entry cost is what got me into it. There is also this thing where if you tell people you spray they assume you are not fast. So it helps for sleeper factor if you are into that.
I did not find it addictive because its on/off attitude is dangerous on the street where traction is low and there are many dangers. My car spends most of its time on the street.
also, just like boost, you can blow a motor. If you are the kind of person who does research and stays within reasonable limits you will be fine.
Also, if you are going to spray alot, you should get a hookup for tanks. Refills at a shop can get expensive and often the employees at the shop don't even want to do it. They have to take time away from good paying work to fill a bottle that does not make the shop much money.
Nitrous can be a very inexpensive way to push a few extra HP, or the dominant figure on your build. The rabbit hole goes very deep. A lot of people don't understand nitrous. Nitrous is harder to understand than boost once you start getting into the thermo aspects of it. For instance understanding how the nitrous transitioning from liquid to vapor to gas can draw large amounts of heat out of the ambient intake air giving you more than just the oxygen that the nitrous chemically supplies. It sounds like a lot, if you are running under 200 you don't need to understand that much really. But for bigger setups, and classes where you are limited by jet size, it pays to know the science.