Is SC a good place to work for a long time (maybe until retirement) or everyone just use SC as a stepping stone to have a great start in commercial world?

I'm quite interested in Audit Oversight Board and investigation stuffs (too much of police procedural movies ).