I've played both ends of the spectrum - and somewhere in the middle. I have to agree with those that pointed out that it's not about position - it's about pleasure and control. I tend to think of having intercourse as 'riding his cock' rather than 'being penetrated'.
And yes, I've heard the analogy of the penis being consumed by the vagina -- where do you think the myth of the vagina dentata came from?
Now /there/ an image to inspire shivers.... of either horror, or delight, depending on your kink.