The Custom Thumbnail tab appears on the Media Details screen only with non-image file types (.mov, .unity, .unity3d, .zoom). This functionality allows users to upload an image to appear as a thumbnail for the non-image asset.