There can be issues if the foreskin is too tight where it can impair the ability of the penis to become erect. If extremely tight, an erection could tear the foreskin. However, these issues are easily treated if necessary.
On attractiveness: a total toss up. Some people consider an uncut penis a turnon, others a turnoff, but most people don't really care.
On hygiene: A wash, while an uncut penis requires more careful hygiene, it's not burdensome, and easily taught.
On the aftereffects: I have only known one man who felt "mutilated" as an adult (he is actually having a false foreskin attached).
The overall: This is one of those where they are honestly going to have to hash it out for themselves. It's really not a discussion with a factual answer either way.
