A Comprehensive Investigation of Metals in the Circumgalactic Medium of Nearby Dwarf Galaxies