I have a big KitchenAid free-standing liquidiser that I seldom use for things like hummus - if you're working with small quantities the handheld is better - you don't waste so much on the sides and nooks and crannies of the mixer.
Now, for crushing ice or making smoothies - or to pick a random example, for making iced coffee - the free-standing one is the only way to go.