Ex-oncology nurse here (and UC sufferer. No stoma though.)
IME, stomas are generally so well managed these days that they can sometimes even seem beneficial, well, almost.
I think it depends largely on the experience of the patient wrt the stoma itself, the diagnosis and duration of the disease that led to it. For example: for bowel cancer, there’s usually an acute period leading up to the diagnosis, with little time to take everything in, and a desire to return to normality ASAP. For more chronic disorders (eg, Chrohns), there’s definitely more time to think about the positives and negatives.
The advent of stoma care nurses practically everywhere has transformed support, and its now possible to get a a system that fits well and can be obtained almost wherever and whenever the patient needs.
My advice would be to consult more heavily with the stoma care team and not just the patient groups.
As an aside, if my UC ever goes ballistic, I’ll happily get a stoma and live with it. Wouldn’t really fuss me too much tbh.
Good luck to Mrs EGF!