Unfortunately I didn't capture the full error last night, and my only Drupal site is already updated so I can't currently trigger it again, but if you search for "drush Unknown archive format." you'll find several other people reporting switching back to php 7.3 fixed it. Taking #540552 and #570228 into account, and php 7.3 no longer being in tree, it's probably best to remove drush entirely.
It looks like php-7.4 uses application/gzip for the *.gz mime type, while drush is expecting application/x-gzip. I will fix that in an -r4, since I need to hack in some more php-8.0 support as well.
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=06d8c8e98a620bf36af1ef4032c630eaf21e098c commit 06d8c8e98a620bf36af1ef4032c630eaf21e098c Author: Michael Orlitzky <mjo@gentoo.org> AuthorDate: 2022-09-27 01:09:37 +0000 Commit: Michael Orlitzky <mjo@gentoo.org> CommitDate: 2022-09-27 01:23:04 +0000 app-admin/drush: new revision with better php8 support and a bugfix. Closes: https://bugs.gentoo.org/865483 Signed-off-by: Michael Orlitzky <mjo@gentoo.org> app-admin/drush/drush-6.7.0-r4.ebuild | 68 ++++++++++++++++++ app-admin/drush/files/drush-6.7.0-gzip-mime.patch | 25 +++++++ app-admin/drush/files/drush-6.7.0-php8.0.patch | 87 +++++++++++++++++++++++ 3 files changed, 180 insertions(+)