Love it. I'm biased because I'm Irish (-American), but I find
Siofra to be delightful and zippy. Since I love both mythological names and Irish names, this gives me two for the price of one.
The only down side, as with so many Celtic names, is pronunciation. "SHEE-fruh" could be a tongue twister for many.