find_library shouldn't really return a path, but instead a loaded library.
This would permit things like ros2/rcutils#143 to not have to worry about paths, and could possibly reduce any possibility of ODR by returning currently loaded libraries rather than loading a new one.