There's more to it than strictly front intake vs top exhaust.
The balance of the airflow (other fans etc), the specific case in question (orientation) etc.
There's no "right" answer, and each have pros & cons. Kyle even mentions that in his video (as do others).
In that video, you can see what caused the issue. The open faced card releases more heat inside the case (blowers at least partially exhaust themselves), heat rises, exhaust fans at the top push "hot" air through the rad, so temps aren't reduced in the rad/liquid as much.
Kyle's numbers are a lot more varied that a lot of other tests conducted... usually you're only talking a 1-2'c swing in either orientation.
There's too many variables to definitively state though, as results only speak to the configs they're tested with.
In theory, you could somewhat "normalize" for the 'warm' air coming in via the front, by populating the bottom (for example) with intakes too. Rear + Top as exhausts. *should* give you the best of both, but is arguably overkill in 99% of systems,.... and would probably be loud.
FWIW, quality air coolers can rival almost any AIO, with less hassle, no real points of failure, more consistent across configurations... and the added benefit of additional airflow.