While the gain may show diminishing returns you will still get a larger shot at the horizon with more height. It will also put your RF further away from neighbors.
It would be fun for VHF/UHF/SHF though!
Plus, it opens up the possibility for phased arrays, multiple yagis with different tx/rx characteristics, and best of all, chicks dig big towers.