Yup, it's like taking the paint back to how it was when it was freshly painted. Invest in a good polish and wax to seal in the shine. You should do this straight after really so that your efforts aren’t wasted - it's bloody hard work!
It's amazing when you run your hand over the paint before and after, it leaves a glass like finish!