Here's my bias - I love going to CrossFit for the people, and the workouts that actually push me.
I think it ultimately is a personal preference - have you tried other local crossfit boxes? When I started, I did bootcamps - I think around 6-7 of them in a row (each of them 4 weeks) - which were supposed to be an onramp but there are a number of people who just do bootcamps. (For bootcamps, they used really light weights, if any / though there were body weight exercises which can be tough no matter how good a shape you're in)
The feel in the bootcamps is significantly different than the regular classes I go to now but I really enjoyed both. I think one of the biggest problems in getting in shape is keeping at it... and I think the community element and accountability is something that's missing for a lot of training programs - which CrossFit, just by nature of its small(er) classes and knowing people, fills well for some people. Being in that environment is a lot easier to push yourself - and for some people - too easy to the point they get hurt (so know your limit, stay within it ;) )
I've never been injured - and I've been doing this relatively consistently for about 2 and a half years now. I've known a few people who have - though in many cases there were pre-existing injuries or mobility issues. I pay about $220 CAD/month but given the classes I tend to go to, there usually average about 5-6 people per class and the trainers are fantastic so it's practically like personal training anyway.
Two relatively recent articles I'd recommend:
and 2. http://www.catalystathletics.com/article/1867/Are-You-an-Athlete-or-an-Exerciser/
I'm not training to be an athlete and I'm way too lazy and not motivated enough to actually compete even in the local competitions (though I happily volunteer). I go with the bf - and have done so for pretty much 2 years which is also nice - a way to spend time together consistently, but with common friends and to be a bit competitive haha. I've seen some very substantial improvements in the last few years and feel (and look) a lot better as a result.
Oh and not to be underestimated, it can be nice to show off or watch others - as it's socially acceptable to work out shirtless - the guys that do work out shirtless are often the ones you actually want to be going through the wods shirtless. That's gotta be worth something?