@NiallC. I'm personally a fan of the pull-out style for putting less wear on the hose (that's just a theory, no practical experience). It really depends on the style of your kitchen, mine is cramped so I looked for things that wouldn't make the space feel any smaller.
@BMitch Some of the stuff I've read online suggests that you have to change your grip between pulling the sprayer out of the faucet and using it. Do you find that too?
So, hand over the sprayer to grasp it, then switch to hand underneath for spraying
@NiallC. It depends on what you're spraying. If you're trying to fill a pot that's too large for the sink, then you just pull straight out. If I'm trying to spray the sink itself (washing off the back and sides), I tend to do a two handed operation to avoid kinking the hose.
My hand is typically over the sprayer, with fingers at the buttons to switch from spray to stream (I intentionally got one with buttons on the bottom where they are less visible)
@NiallC. just as important as how it works is how it fits your home, find something that matches your style and space. If you're anything like me, it will spend a majority of it's time in the retracted position.