c/driver_manager: refactor searching/loading

### What feature or improvement would you like to see?

https://github.com/apache/arrow-adbc/pull/3681

Ideally we would be able to factor our searching and loading entirely so they're unit-testable and we can ensure internal invariants. This would also help with improving error messages.