I'd tell him I supported him, as he's family. However, if he wanted a voluntary medical procedure like that done, he'd have to finance it himself. Just like if I had a daughter that wanted Breast Implants.
It would probably affect our relationship, but what major life event doesn't?
My main concern would be that he do whatever he needed to do to be happy.