As what may be the youngest ostomate [2 months post op] here I will tell you what I know.
You can investigate as much as you like but it will be all different to what you expect. Get to be close friends with your stoma nurse, there is no one better to tell you all you want to know. They are better than your urologist in that regard. Sure your urologist knows all about your operation but the physical and mental situation is the realm of the stoma nurse.
My bladder was removed due to cancer and I am now hoping to be totally cancer free. The pain after the operation was horrific but was handled by a constant drip of pain killer at first, then by my pressing a button to deliver more as needed. I was out of hospital in six days and took 4 more weeks to rest before flying 3000km home to the Philippines.
It is a whole change of life with your bag, and you will make many mistakes in the early stages but like life, you learn quickly what you can and cannot do.
I was told that many would find the bag offensive but I have found the opposite to be the case. No one at home minds seeing my bag under normal circumstances. Though when the Prime Minister, President calls at my home, I do cover it.
To sum up, ask your urologist all about the operation, but ask your stoma nurse every other question, don't be shy, she has heard all the questions before, talk about sex, or any subject that worries you. She will always be your best source of knowledge, but places like this and people like these here will always be there to talk to when needed. I have and it is good to be able to let off steam here that you bottle up elsewhere.