Love it. As someone else said upthread, it's one of the few surname/first names that I really like (some of the other Scottish ones are nice too).
DH ruled it out for DS because of David, but most people don't seem to make the association - the next generation of schoolchildren will probably not think of David Cameron at all.