SCP-XXXX is a middle-aged woman previously residing in ███████, Canada
This reads a bit awkwardly. I would recommend "SCP-XXXX is a middle aged woman who previously resided in (location)"
When in the immediate vicinity of SCP-XXXX, human subjects invariably report feeling safe and appear to trust SCP-XXXX unconditionally.
What defines immediate vicinity? Will subjects feel this if they are 2 feet away but seperated with glass? Does the effect occur whether or not subjects are looking at SCP-XXXX. While cell dimensions are better off being vague, the mechanism for SCP really needs to be made crystal clear for the Foundation.
SCP-XXXX is generally amiable and cooperative with foundation personnel, but upon sighting a small percentage of subjects
Foundation needs to be capitalized.
"upon sighting a small percentage of subjects" is a bit problematic. The use of "percentage" almost demands that you provide one, or an estimate at least. I believe what you were trying to say is that only a few personnel get 'chosen.' This can be made more clear. For example:
"…cooperative with Foundation personnel. However, SCP-XXXX will occasionally 'select' someone experiencing its primary affects and (rest of sentence here)."
it requests for them to "come closer". Given the primary effect, subjects will invariably comply with this request.
Be aware that you have created a compulsive SCP. It may not be explicit, but it may as well be. This site has a lot of compulsive SCPs. However, the main issue with compulsion(in a lot of cases) is that they simply aren't interesting. Effects being triggered based on free will are interesting, more so for harmful effects triggered by free will. Compulsion removes the human aspect of the effect and more or less just turns the victim into an automaton that's screwed by no choice of their own. Furthermore, this statement doesn't state that it's impossible to stop the secondary effect from occurring. A subject can still be stopped by someone else physically restraining them, or by placing a barrier between them and SCP-XXXX.
Upon contact, SCP-XXXX's secondary effect will manifest, slightly altering the appearance of the subject and causing a significant alteration of identity, generally consisting of a change in personality, mannerisms, names, and often pronouns, although the subject's memories remain entirely intact.
I didn't really understand any of this because none of it was described. Does the subject become younger or older? Do subjects adopt the identity of someone else specifically, or just another identity in general? If they adopt a new identity, how do their memories stay the same? I recommend seriously revising this portion so that it conveys an image.
claim to have a better understanding of themselves
Once again, what does this mean? Vague statements like these, which can be interpreted in many ways, don't hold clinical tone. Keep in mind that these documents almost always have to sound as though they are written by a detached Foundation researcher, no matter the horrific or hilarious or happy nature of the SCP.
The description makes no mention of SCP-XXXX's tertiary effect, which occurs when it enters a distressed state. This is likely the most important aspect of SCP-XXXX since it can affect subjects outside its cell. Since the procedures have been revised to account for it, it makes no sense that the description hasn't been similarly updated in the wake of the incident.