I know reality is sometimes different from official policy, but for the record, straight from the horse's mouth:
https://www.faa.gov/pilot-mental-fitness
For me it's completely moot. I can't even have someone else fly me anymore--I have an (apparently untreatable) eustachian tube dysfunction.
...which is probably for the best given my bearish position on aviation.