Ultimately the CPU cooler you get ultimately depends on what CPU you get.
For low heat CPU’s - budget air cooling is the best value for money.
For medium heat CPU’s - AIO cooling or medium-end air cooling is the best option.
For high heat CPU’s - Liquid cooling or high-end air cooling should...