Another missing point here is that all of this depends on table size, indexes in place and data distribution the plans can change depending all of this

It is never a clear shot to simply compare (sub-queries vs joins) the right answer is "it depends"

Just my $0.02