Banned accounts will still be publicly visible. Deleted accounts are fully deleted with all content they created. Their questions are changed to be anonymous, their responses are deleted, circles deleted, comments, reactions, etc. Make sure you include the @ in the URL when trying to find a profile!