I have squeaking front and garage entrance door hinges in my house I
need to spray with lubrication during the winter because it gets so
loud. I used WD-40 a couple of times, but the irritating noise would
come back only after a few days.

Someone told me to give silicone spray a try, so I might do that, but
thought I'd pose a question in here to learn when using one over the
other is better.

Is metal on metal contact for WD-40 and the silicone spray for
everything else? Please clarify. Thanks!