I think any dog would make a great dog detective but you need to know a lot about that breed and how you could train it. Dogs are a very smart creature but the thing is you need to put a lot of time and effort into training. Also when you train a dog to be a dog detective start when it is a puppy it will learn more. Like they always say never teach an old dog new tricks.
Ps if you need how to train a dog send me a letter and you would be the dog expert