Picaridin and DEET are roughly equal in effectiveness, but picaridin is safer for pets, and doesn't have a nasty habit of destroying synthetic fabrics.

Anecdotally it’s useless. I’ve seen them walk right over DEET sprayed boots. They freeze up pretty much on contact with permethrin.