It's a beautiful name. I like the tragic Gothic flair it has. I think I prefer it as a middle name though. It would do wonders to turn a rather humble, everyday sort of name into something poetic. It would be harder to pick a middle name for Ophelia that didn't either turn it into a shrill operatic aria, or make the middle name look about as filler as leftover bologna.
As a first name it's a little theatrical even for my bizarre tastes. But as a middle name it shines.