@zixhaa I confirmed the same test with the same parameters. When set to "Closed", auto-join worked when using the Admin-Issued Registration URL with "Approval required" unchecked, it auto-joined the guild upon completing registration. When testing it with "Approval required" checked, then it created the account but did not auto-join the guild and left the account hanging without a guild.
Thread
Comment by @whenbearsreign