It is worth considering what an axial fan actually does to the air.
If you've ever put your hand in front of a fan (the side that blows air towards you/your hand), you feel a very noticeable and strong flow of air.
On the other hand, place your hand behind the fan - the side that is sucking air in - and you will feel much less air flow.
Of course, the fan is sucking in as much are as it is blowing out, so why is there such a noticeable difference?
Fans work by taking slow moving air and accelerating it to high speed air. This results in a relatively tight column of faster moving air being blown in a direction (along the axis of the fan blade's rotation), while slow moving air is sucked in from pretty much all directions in a just under 180° arc, horizontal and vertical from behind the fan.
If your cabinet is poorly sealed and dust is a primary concern, then you probably want to have the fan at the bottom pushing air into the cabinet.
However, if your cabinet is fairly airtight except for the intake and exhaust vents, then you will get superior thermals for anything passively cooled inside by putting an exhaust fan at the top instead.
The hot air will naturally move to the top of the cabinet and without much preference for where, and an exhaust fan at the top will suck in all the hottest air from all directions at the top, exhausting it out in a column of air up and away. This results in much more even removal of hot air, keeping the ambient temperature throughout the entire cabinet lower.
If you have the fan blow cool air in from the bottom instead, you will have much greater turbulent effects from the higher and more directional air and depending on the location and shape of whatever is in the cabinet, this can have a quite measurable detrimental effect on thermals over all.
If you are blowing air out, you can blow it out into a clear open space, while the air being sucked in by that fan is all going to come in from the easiest (lowest impedance) paths, whatever they may be.
If you are blowing that directional column of fast moving air into the cabinet from the bottom, some of it is going to impinge on surfaces inside the cabinet (or the cabinet walls themselves) and generally not flow as well out of the case. Additionally, hot air will not be removed evenly, and the part of the cabinet the fan is blowing directly at might be cooler than the average temperature you'd get with an exhaust fan at the top, you will have the potential for various pockets of hot air that are not really replaced with new, cool air as efficiently.
But the overall average temperature will be lower with an exhaust fan at the top. Simply because you get more air flow that way. Static pressure is static pressure, the fan only cares about the pressure difference across it. Exhausting means lower (negative) pressure on the intake/inside the cabinet, and higher pressure at the exhaust. Intaking air means .. lower (negative, relative to the cabinet insides) pressure at the intake and higher pressure on the fan's exhaust side, only now it is exhausting into the cabinet. There is no difference from the fan's perspective. Either way, there is a static pressure gradient in the same direction. It makes no difference.
BUT...consider why hot air rises. It is because it is less dense. What does that mean for a gas? Higher pressure. Just look at hot air balloons - the whole balloon is inflated and given structure simply by heating the air inside, producing positive pressure.
So intaking cold air from the bottom is going to create positive pressure inside the cabinet... but there is already some positive pressure in the cabinet simply from the air being hotter than outside the cabinet. This increases the static pressure on the fan must overcome, which reduces the air flow a given fan can achieve.
If, however, you have a fan at the top exhausting air, you have slightly less static pressure across it. You have the positive pressure from the hot air inside the cabinet trying to push out, and a fan that is trying to exhaust it. Where the intake fan is acting against this pressure, the exhaust fan is aided by it. The result is a measurable improvement in air flow vs. the intake fan. Just think of it like this: is it easier to inflate or deflate a balloon?
The improvement can be significant or negligible (more often the latter, or at least a fairly modest improvement) depending on all sorts of factors. But it will be there and be improvement all the same. If you are confident that little to no unfiltered air will get sucked into the cabinet, you should go with an exhaust fan blowing out the top. If you have lots of cracks or seems air can get into though and are worried about dust, then go for an intake fan at the bottom for the positive pressure. Just be wary of hot spots etc.