My XDH and I did not find out for the first two and it was a wonderful surprise.
We where so overwhelmed when I first was born the midwife had to ask us if we wanted to know
The next five I found out what we were having but that was more a logistic thing, it was easier to get everything sorted before the birth and we named them so the other kids used their names for the pregnancy and it encouraged sibling bonding...I don't think it took away from the birth at all.