If they are not unique it seems like they should be. Having to create a relational document for a username seems like much more work than just having the option to make the user model name unique.
TL;DR
Appwrite usernames should be unique. It is currently suggested to create a unique username to avoid extra relational work for developers.