A Stoma cap is "doable" for intimate times, as long as it doesn't last all night!! hehehe
Minis are better, since you can go a couple of hours before having to empty, but I don't recommend wearing one overnight. I did that once, and I thought it was going to explode!!
My husband is like Ohio's, he could care less about the bag, so I just wear a maxi all the time.
I also like to wear a short nightie to bed and then just keep it on during intimate times.
Hope that helps!