I suppose the best "tips" I have to offer are as follows:
-With potential partners, don't make a huge deal out of your bag and act like it disgusts you or you despise having it. I have found that our attitudes towards things can be contagious. Don't be afraid to have a sense of humor about it, and explain it to your partner like they are five years old, just to ensure that they understand and aren't needlessly afraid of it.
-If the bag gets in the way, just say "oops", and move it out of the way. Having the bag get in the way shouldn't be a reason to completely stop dead and get flustered - unless of course the bag has exploded or you've hurt your stoma.
-If you're with a partner and they are performing oral sex on you, just gently move the bag out of their way so they don't bang their head into it if they start getting wild. I've done that a number of times, and while it NEVER grosses me out, I worry that I might have jarred his stoma or something
-Try out all sorts of different positions. Not only is this incredibly fun, but it teaches you what works for your own individual needs as far as maneuvering with your bag. So far, my husband and I haven't run into any problems, but everyone is different so I figure that this bears mentioning.
-Have a sense of humor with yourself, and treat the little noises the bag makes like any other bodily noise. Your bag is now a part of your body (for better or worse), and when the material makes a crinkling sound, or if you pass a bit of gas, it's no big deal. Just think of the crinkling bag noise as no different from the shuffling noise your clothing makes, or the sounds your joints make if they crack.
I'll post again if I think of more, but hopefully that should suffice for now.
Cheers to having good safe fun