I think I have had about every size going over the years. I think the biggest I have had is was a Silverstone TJ07 but currently running a M-ITX system in a Bitfenix Prodigy. The Prodigy still isn't that small but I needed the room for 3.5" drives and with a 200mm (230mm?) fan in the front it isn't particularly noisy either.
If space is tight then M-ITX may be the way to go, there has been some high end M-ITX boards which still give you overclocking, NVME support etc. Obviously M-ITX still has its limitations in that they mostly (if not all) only can take 2 RAM sticks, only 1 graphics card / expansion card, have less S-ATA ports etc. As a general rule, smaller cases have smaller fans or fans have to run faster so they will be noisier than large cases. However it really comes down to what space you have, if space is that tight then you may have to pick a case first then choose the components to go in it.