Well, like anything, there’s appropriate usage and inappropriate, the latter usually being in the operator ‘showing off’ category.

They come in quite handy for things like aerial inspections (roofs, chimneys or other places hard to get to). If you’re selling a house it can give perspective and show the house in relation to the neighborhood, city or countryside.  I’ve used them often in huge warehouses to show off massive automation installations. And, of course, there’s the arty aspect–music videos and the like.