I’m not super familiar with how hardware works so this might be a stupid question but how different are the tiers of processors for each upgrade and what’s a re

I’m not super familiar with how hardware works so this might be a stupid question but how different are the tiers of processors for each upgrade and what’s a reasonable use case to choose any of them?