Yes. As a young man I made some pretty stupid decisions based on sex, and yes I would say I was delusional.

As a prostate cancer survivor, sex doesn't cause delusions anymore, nor do delusions cause sex.