Anecdotally, during the ongoing parts shortage, no-lead packages were generally the first to disappear and continue to be the hardest to source, and QFPs easier. On the other hand, some of the latest chips (e.g. STM32G series, with its backwards-incompatible pinouts) have been more available, probably because people haven't included them in many designs yet. For these reasons, I've redesigned several boards to 100% QFP and switching from STM32L to STM32G. In the long run of course the trend is toward miniaturisation as you say.