So, to put it somewhat in perspective: listed TDPs for CPUs are a lie beyond stock. We all know this, but it's hard to understand just how much, and how that should inform CPU cooling decisions.
One good current example is Intel's 12900k: Intel was honest, this time, and put the 'stock overclocked' power limit of 241w on the marketing. Put simply, 241w is beyond what the best single-tower single- or dual-fan coolers like the Hyper 212 are capable of handling. At best you'll be dealing with constant thermal throttling, but you'll probably also see crashes depending on what workloads you run and how your motherboard is set up.
Another example is the CPU I'm using in the new case review rig, the 10900k reviewed by
@Dan_D a few years back. Under Dan's custom water loop, the CPU was able to pull up to 300w - this on a CPU with a 'stock' TDP of 95w. For my testing, under a Dark Rock Pro 4 like
@David_Schroth tested earlier this year, but with a third Shadow Wings 3 fan installed, I've had to limit the 10900k to 5.0GHz to keep it stable for the broad swath of testing we do.
And that's pushing to 260w+, for ten Skylake cores at 5.0GHz, which is at the present time able to outscore Cinebench R23's Threadripper 1950X sample result by several hundred points, for comparison, while staying just below 90c.
Large is both an understatement and an overstatement - yes, these coolers are quite large, but usually in dimensions where that doesn't really matter. They're still shorter than necessary for most mid-tower ATX or mATX cases, for example, and most can easily overhang taller RAM sticks.
Where the size really becomes a problem is in working around the cooler. Note in the review here of the MA624 that the removal of a fan isn't required for installation and removal and that's an important take home point. In contrast, the Dark Rock Pro 4 requires the removal of the middle fan, which further necessitates the removal of the GPU. This is a pain, and on top of having to route the three fan power leads around, marks a pretty big difference between large-tower air coolers and AIOs.
Honestly, while I like be quiet!'s products, styling, and pricing, that ease of installation puts the MA624 squarely above the Dark Rock Pro 4. I hadn't worked with larger air coolers, having preferred and still largely preferring AIOs, and the inconvenience involved in properly security the Dark Rock Pro 4 isn't something I'm likely to put myself through unduly, or recommend outside of necessity such as market availability or hard budget limits.