Where do I find information that explains the Top Secret security algorithm search sequence (ie user id, profile, ALL record)?
The search order is determined by the AUTH control option setting. See AUTH Merge Records for Search for what each setting does. A TSS MODIFY can be issued to see the AUTH setting.
See Resource Access Security Validation Algorithm for how the security algorithm works in Top Secret.