I do like the Band's song The Weight, which is much better than The Night They Drove Old Dixie Down. As Hungry101 mentioned the Band's version sounds out of tune and Levon Helm's vocals do not work like Joan Baez's. You are right about a female singing a song narrated by a male character, it is strange, but her vocals are great and Levon Helm's are not. The Weight somehow worked better for the Band, in my mind. The Night They Drove Old Dixie Down is a great song and I am very surprised that some other artists have not covered it since Baez did. In 2020 it may be a bit controversial to do so, but back in the 1970s I can think of lot of singers who could have done better with the song.