Look, in the grand scheme of things the mob would far rather you recognised you had a problem, gripped it by seeking help and cracked on.
Theoretically - unless you were med boarded S8 - there should be no impact on your career or rather, in an ideal world, there should be a positive effect in that your CoC should recognise and respect the fact that you had the gumption to try and get it sorted.
Of course, that's 'theoretical' and in an 'ideal world'
There will be no effect my friend. Its a chain of command responsibility, and if you dont get help, your career may suffer more from a natural dip in performance.
I think that even in the last three years, the change in perception of those who need help after tours has been entirely positive. This has come about not only from improved taining in the chain of command, but also from the blokes all realising that its not nice out there!