We have two boys, 2 and 4...they can certainly make it difficult for us to get "mommy and daddy" time in if we don't want to wait until they're asleep for the night. our oldest will generally sleep through anything, including our loudest/most vigourous play time...our youngest, it's a toss-up. The days that they're being particularly trying can certainly put a damper on any desire for nookie.
Funny story...one night my wife's riding me, and we're going at it hard and heavy. At some point our oldest wakes up and quietly opens our bedroom door...no idea how long he had been standing there watching us, but eventually we hear his little voice ask "daddy, what are you doing to mommy"? Bam...instant boner killer. My wife was mortified...
What we're really worried about is being walked in on during pegging play...oi. Don't want to have to explain that mommy really doesn't have a peen, and why it's ok for mommy to put her not-peen in daddy's butt when we've told him not to put things in his butt (well, not to put things between his buttcheeks)...