Do you think it's possible to have a well-written Mary Sue? If so, who would be an example?

Depends on context what you want to write about Mary Sue. Poorly writen Mary Sue are definitely better than well writen pro-colonialists and police apologia’s stories.