Are DAO Tiers different from Superfan levels?

Yes, the DAO Tiers are your membership level on the Platform and Superfan relates specifically to a project or projects fans are engaged with and supporting.

Fans can have multiple projects where they are Superfans but they will only have on DAO tier ranking per account.