You hear both so-FRON-ee-a or so-FRON-ya in England - depends really. You're more likely to get the first from a Catholic (there's a Sofronia up for canonization I think) or Greek families (my Cyprian
friend says it that way) while the other is more mainstream English.
No one famous but I saw it in the obituaries (not morbid, they're right below the birth announcements and your eyes wander ;o) not too long ago (last 6 months or so) - the surname was Greek and it announced a Greek Orthodox service. And I know it's still used in Italy and parts of Eastern Europe so perhaps there's a musician or actress with the name lurking out there.Devon