Lesbian characters rarely appear in opera; Countess Geschwitz in Alban Berg's Lulu is one exception, but Charles Gounod's Sapho portrays the poet as straight.
In theater, there are quite a few plays and musicals that have lesbian characters or focus on lesbian themes.