your experience with depo?

Going to the gyno tomorrow and I'm thinking about getting the depo shot. However it sounds really scary. I read that if you experience side effects, the side effects don't wear off until the vaccine wears off, which is 3 months. 
I was on the pill a couple years back and experiences weight gain, it also killed my sex drive. Are these things any of you ladies have experienced with the depo shot?