Upvote:2
As far as I know, the Church has no official policy on "self-enhancement". Medicine, even psychoactive medicine, in areas other than fertility and euthanasia is largely a secular issue. If your fictional drug appeared miraculous (read: unexplainable by science), then that might be a different matter. The power to perform miracles is, in Catholic doctrine, granted by God, and the Church might declare that such a drug is heretical or magical, and therefore sinful to use.