Any aperture will produce this result, it's just that a larger aperture will produce a fuzzier image, so at one point it will just blur beyond recognition.
Basically every tiny detail in the image is spread out over the area of the shape of the apeture, but if you spread out the image over a large area you can get a pretty decent quality image.
The size of the image is determined by the ratio of the distance from the focal point to the sun and the wall respectively.
In this case the focal point is in the aperture itself but if your using a lens it can be elsewhere.

Diffraction only comes into play when you have a really tiny aperture.

And what is neglected in this video is that if you live way north, like here, it really doesn't matter anyway since it's either dark during most of the day in the winter or bright in the summer.
So all DST really does is move when it's slightly less bright at midnight by an hour.