If you use middle-clicking to paste into Emacs windows but don't like how the paste occurs at the click location and would rather paste at point, use this in your ~/.emacs:

(setq mouse-yank-at-point t)

Thanks to Kevin Turner for pointing this out.