While all dogs have the potential to be 'great dogs', Will Atherton cautioned that some breeds are more challenging to own