If a SF recruiter is telling you about getting attached to ODAs, I'm not sure what he is trying to accomplish. I misread your post and thought you were joining the Army. If that had been the case, I stand by my statement of declaring doucheitude. Keep the recruiter? SF recruiters recruit for SF, not support positions, which are assigned by your respective branch at HRC. Maybe the guy you're talking to is a douche. I don't know him, probably, but it's impossible to know for sure whether or not he is a douche if I don't know the guy. I don't care what he does for a living.
You wanted the low down on being attached to ODAs. What you end up doing depends on your MOS, your competency/tactical and technical proficiency, mission requirements, the mentality and needs of that ODA. Through two different Groups, as far as support guys, I've known some of the absolute worst, and some of the best people I've met in my own career field. It is extremely hard to get rid of the shitbags, and the shitbags are occasionally in leadership positions... because there is no selection process. There is one job, 35P, where I think Group is typically a good assignment. Otherwise, it is totally hit or miss. Again, if you want to do "cool" stuff, pay the piper and go to selection.
As has been stated, the CRDs in Group do SSE, which sprung out of not having a real mission during the current main efforts, OEF and previously OIF. Their mission is... Chemical reconnaissance. Don't have a useful purpose, find one, sort of thing. SSE is a relatively new thing in the military. In the good old days, most of the SSE expertise only existed in the MP Corps, but because of lessons learned during our recent wars, the typical people doing it are guys on the line with additional training (11Bs etc), or other random MOSs. MI is actually the proponent for SSE now, but the SOF community has their own courses they run or do through contracted training.
I apologize if I come off as being a dick. Not much to cheer about lately. Good luck to you, whatever you end up doing.