Optimized single-crystal diamond scanning probes for high sensitivity magnetometry