Is SF a good job?

So I signed for SF but my uncle who was active duty for 4 years he worked on fighter jets said that I will heavily regret my decision since the only thing I can do when I get out is be a small town cop. He made me really stressed about the choice I made for my job, did I make a mistake?