Multiple file formats embeds their alpha in the standard, non-premultiplied, format leading to ugly edges around transparent areas when the engine interprets those as premultiplied. There's a couple of reasons to use premultiplied alpha, you can google about this subject if you want to read if/why you should do so.
PSD outputs standard alpha out of the box, to have decent premultiplied results with that format you'll have to create an explicit alpha channel and use it as a global mask for the whole picture, if you have multiple layers with different alphas it becomes really tedious to manage that channel for every changes that you make.
TIFF on the other hand outputs premultiplied alpha and, for photoshop, converting PSDs to TIFF is mostly non-destructive as the format itself can be lossless and embeds all of the photoshop layers, groups, masks and such in the file.
Stride's texture transparency block has an Alpha property which describes how the alpha is interpreted and compressed when stored in GPU