Mary Sue

The most common type of Mary Sue is a character based an the author's idealization of themself. Furthermore, because the author is imagining a preferred version of themself, and because faults are overlooked in favor of optimization, a Mary Sue tends to have only superficial resemblance to the author, sharing similar likes/dislikes and a similar spirituality (when applicable), but objectifying things such as worldview and relationships. This type of Mary Sue is more common simply because it's easier to write and is more appealing to the author. This Mary Sue is found in fanfics and original fiction alike. Yes, Mary Sues abound even in professional writing. The other type of Mary Sue is a character intended to be an ideal match for another, appearing almost exclusively in fanfics. In this case, "ideal match" means that the character's positive traits are exaggerated to render impossible any competition for the love interest. Arguably more pernicious than the "self-idealization" type, the "ideal match" type by its very nature prevents compelling character or plot development, which the "self-ideal" Mary Sue may be able to avoid.