Hypnobirth

Any positive hypnobabies/birth stories? I am 8 weeks with my first and want to try hypno/water birth and have a doula with me if possible. Anyone start the courses and have a relaxed birth or totally abandon and go for pain relief? am I in fantasy land?