When working with data from different sources, they often come in with different EPSG codes, even when they are using the same nominal projection. For example, I often work in Washington State Plane North NAD83 in US feet. Using QGIS I generally select EPSG 2285, but when I'm working with a shapefile generated in ArcMap, it often comes in on EPSG 102748. I recently opened a geodatabase also in Washington State Plane North NAD83 in US Feet that was in EPSG 6597. A search on EPSG.io also lists EPSG 32148 as a Washington State Plane North NAD83 in US Feet.
When using QGIS all of these appear to perform the same, and I haven't run into issues with with strange results because of different projections. None of these projections appear to be deprecated, and I haven't found anything to recommend one vs another. Is there any reason to prefer or avoid any of these, or am I getting concerned over trivia?