Creatine doesn't provide a pump. It doesn't super hydrate your muscles. That's not the purpose or desired effect at all.
Creatine is used, in conjunction with calcium, to contract your muscles. Nothing more. Creatine supplementation should allow you to get a few more reps in before fatiguing, which could lead to better gains in the long run.
Its not magic stuff...and its why its one of the few things that does actually work (unlike Glutamine, and all the "NO" products).
All you need is 100% pure Creatine Monohydrate, preferably with 'CreaPure' processing stamped on the back. Should be like $16 for 500g