Is it worth it? great question! and ultimately only you can answer that, and worse yet, it's nearly impossible to find out without taking the plunge and putting considerable hours on one. That said, I know no one who has turned back having once crossed over.
When I made the switch I had done about 600 single tank, NDL air dives... mostly from shore. Doubles seemed like to much trouble, Nitrox didn't offer an attractive hassle to benefit ratio but still I was getting tired of feeling like I was rushing to get to the sweet spot of a dive only to get low on air or close to the deco limit and have to return all too soon to the surface. And the more aggressive I dove the more exhausted I'd feel... nitrogen was not my friend, particularly on multi day dive trips. I was experiencing a variety of considerable frustrations, particularly on adventures to far distant seas. When I started adding up the cost of getting there, the time and effort and then the long boat rides to that precious coveted spot in east jesus, just to do a 35 minute high current dive or have some DM shake some f-ing rattle at me telling me my time was up, I began to see that sport diving using an OC tank was really quite limiting and expensive for what I was getting out of it. The fleeting experience of diving single tanks was getting old and yet tec diving just seemed like way to much trouble... I felt caught in the middle and I was beginning to loose my passion for diving. that was over 3 years ago.
About that time I started to notice rebreathers more and more. Something had changed... they started showing up at recreational dive sites in greater and greater numbers... And they appeared to be relatively well built compared to the contraptions I had seen and heard horror stories of in previous years. The economist in me started crunching the numbers ... the scales appeared to be tipping in favor of rebreathers in terms of cost per minute of bottom time and effort spent. I really got excited when I realized I could significantly increase how long I hung out at that "sweet spot", dive in moderate current without blowing through my gas supply and stay warm, more hydrated and experience less nitrogen fatigue. The beauty of having a nitrox blender on my back, being able to optimize the mix on the fly became more and more alluring... Finally it seemed that there was a type of extended range diving that offered enough benefits to be worth the investment in training, time and money... I was hooked!
I went into rebreather diving with relatively modest goals: I wanted to extend my depth limits only somewhat while mostly being able to stay down longer.
After a couple years into it, I have to say that it breathed new life into my passion for diving, opening portals into whole new realms. Putting a rebreather on your back isn't just like adding doubles, it's like adding 5 or 6 tanks, each with a different nitrox mix...with virtually no MOD. you can dive until you want to stop, not just until you run out of gas. Now when we go half way around the world and find that precious reef with 100% saturation of life, we get to take our time at each level, no rush, and when we find that "veign of gold", we get to hang out there pretty much till we are ready to move on.
I think the benefits of extended range diving using a rebreather are well within the reach of the avid sport diver and I think many sport divers will find, as I did, that going deeper for longer is now an option well within reason. I'm now venturing well below recreational limits.
Usually next to expense, the big question is weather it is worth taking the apparant risk associated with diving rebreathers, particularly only to dive them within recreational limits. That is a complex topic and there are many opinions about it. For an in depth exploration into my opinion on diving style, rig design and risk, check out my comparison contrast article at the top of the rebreather page... but remember, it's just my opinion and ultimately everyone has to come to their own conclusions and determine the level of risk they are willing to take.