I planned water births for all three DCs at home. First one was lovely, well apart from about a week of 'pre-labour', but when I finally went into labour proper it was excellent. Also good for resting in while heavily pregnant, as takes weight off everything.
First labour. Lovely, calm, relaxing. Dozed between contractions. Straightforward second stage and minor labial tear (sorry if tmi). Felt empowered by the whole experience.
Second labour. Completely different. Backache labour even though DD in 'correct' position. Had to get out of the pool as wanted to sleep! Did so for about an hour (probably wouldn't have been allowed in hospital). Gave birth on the bathroom floor very fast. Again, a good experience. Water useful in first stage but not as helpful later on.
Third pregnancy. Got a lovely pool with a heater so it could be set up in advance (can take 2-3 hours to fill a pool at home). Lovely to lounge around in with older two in later stages of pregnancy. DC1 got over fear of water thanks to that, as an added bonus! Gave birth in water very fast (1/2 contraction!). Did get a second degree tear but healed without stitches. Delivered placenta myself in water (unless policies have changed you won't be allowed to do this in hospital).
I was very lucky to be able to afford Independent Midwives so I could choose who to be there at the birth and, I believe, that made a huge difference to the care I received. I had the same primary midwife for all three births and the secondary midwife for the first two was someone I had known since childhood. Both had had children themselves and this seemed important to me, certainly the first time.
I had no other pain relief at all, though could have had gas and air. I was only examined if I requested or if the midwife requested so was examined once in each labour. I examined myself in last labour! Midwife used a waterproof sonicaid to check baby's heartbeat regularly in all three labours.
My advice, though, is that you may not know what you want right up until the point you go into labour. I was looking forward to a repeat of labour 1 with number 2 and it was totally different. Try to be as open to how you feel at the time as possible and do what feels right to you. You can always use the bath/shower at home in early labour and see how that feels (but check temperatures for bath water as that is quite important).
Good luck!