My wife has seen me in diapers several times. Now that the kids are grown and out of the house, there isn't any need to be real secretive or hiding things. If I'm not in the house when my cloth diapers are done in the dryer, I'm likely to find them folded in a stack on the counter in the laundry room, with my plastic pants drying on a hanger.
As far as wearing them around her, she's actually asked me to get diapered before bed a few times. I prefer to lay down on the bed to put them on, and she sometimes goes to bed before me, if I'm watching TV. If I "diaper-up" after she's gone to bed, I tend to wake her up as I'm going thru the process, so she asks me pretty regularly to get my diaper on before I sit down to watch a movie. ( That's ALWAYS a clue that she doesn't plan on staying up long.)
We have 2 bathrooms, one off the main bedroom. I keep my diaper pail in that one, so visitors don't see it. Sometimes in the morning, if we're rushing around getting ready for work, we'll pass each other while I'm headed to the bathroom. If I've had quite a wet night, she might say "Well, you certainly needed a diaper last night!!" or "Better a wet diaper instead of a wet bed!" She never says it in a mean tone, always light-hearted, so it doesn't bother me.