I like to see angles that exaggerate perspective. An example - I once saw a movie in which the girl was in the piledriver getting anal and the camera moved in close (really close, was kinda zoomed as well, I think) to her pussy. She reached down and spread her lips and you could see her smiling up at you between her pussy lips. It pulled back just a bit after a little while and you could see pretty much the entire girl filling the screen. It's a damn shame I didn't buy that movie when I had the chance. I have no idea what it was now.

[Link]

There's something to be said for wide shots too but a good movie should have a nice combination between wide and close shots and plenty of variety. Too much of either kind of shot gets monotonous. If it stays in close up for what I think is too long, I start feeling the anxiety building waiting to see a shot from a few feet away. The longer it goes, the more the anxiety builds and I start to lose my focus and my wood. The same goes for a wide shot (or any, really) that's held for too long.

[Link]