You might need to clarify what you mean by long-term and delusional.

I was a caregiver for two delusional people. My mom unexpectedly developed post-anesthesia dementia for the 6 mos prior to her death. My ex developed a recurring psychosis during the last 15y of our marriage.

They were very different events. IDK if either is similar what you're considering.