I believe it's like so many aspects of sexuality (and possibly moreso for women) in that I think the psychological aspect is by far the most important - if the idea turns you on, and there's nothing in place to ruin the moment (problem cocks, lack of warm up, not taking it slow, etc...) I'm sure you'll love it!
Of the three relationships I've had where we've had an MMF, all three of my girlfriends found it very enjoyable. One came during every time, very hard, and the other two found it hard to hit exactly the right spot during (it is quite limiting to movement) but came very hard and easily immediately after, again on every occasion.
Anyway, that's just my experience, but if you're excited by it, I'd definitely suggest going for it, but as always, go slow and use plenty of lube!
(Side note: CJ - my other half - discovered that she can also both take and enjoy DV despite being quite small in stature and tight of pussy, so don't limit yourself, either!)