H.264 and H.265 (HEVC) are widely used capture formats for DSLRs, mirrorless cameras, action cameras, and phones. H.264 is also the preferred format for uploading to YouTube and social media sites. These compressed formats are well suited for capture and distribution, but they are processor-intensive for post-production.
If you work with H.264 and H.265, consider Intel Core i7 and Core i9 processors, which offer Quick Sync hardware acceleration, supported in both Premiere Pro and After Effects.
AMD and Intel Xeon processors work well for other formats, such as cinema camera formats, (such as RED, Sony Venice, ARRI) and broadcast formats (such as XDCam HD).