I see these issues all the time. Developers create applications that require specific collations at the server level, because they don’t handle temporary tables (and by extension) tempdb well.
All this can be avoided, and you can easily build applications that will work with temporary tables, without worrying about the server (and tempdb) collation.
Read on to learn more about the problem and what you can do to mitigate it.