If he buy 2nd hand, it may not have 99 years left in the lease.
Even if he did not live more than 99 years, but if he decides to sell it. Will it affect the value due to a large portion of the lease already used up?

Freehold is of course better. Better doesn’t mean more worth it. You need to compare the price and location to see which one more worth it.