I think Opal is one of my favorite jewel names. It's very elegant and sparkly.
I think it works nicely as a first or a middle name, but my feeling is it's the kind of name that if you're going to use it at all, it should be the star, and the middle name should be something fairly simple and not overly flashy.
I think, therefore I judge.