No project shows up: OutOfBoundsException and other errors

Problem/Motivation

On a fresh install of Drupal 10.3.6 I've tried enabling all the provided sources one by one and all but the default without this module (Drupal.org JSON:API, Drupal.org Drupal Recipes, and Drupal Core) returned errors in the logs (not on the UI, but the list at /admin/modules/browse was always empty):

ECA Drupal Recipes, Kanopi Studios Drupal Recipes, Packagist Drupal Recipes returned:
OutOfBoundsException: Package "drupal-eca-recipe/eca_lib_0001" is not installed in Composer\InstalledVersions::getInstallPath() (line 241 of /var/www/html/vendor/composer/InstalledVersions.php).

Packagist Drupal Modules & Packagist Drupal Themes returned:

The column filter only works with sequences/mappings or "Traversable", got "NULL" as first argument in "__string_template__82bcafad2d3945eea862d3a6191d8976" at line 1.

Packagist Drupal Modules also gave this longer error:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1: INSERT INTO "key_value_expire" ("collection", "name", "value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => project_browser [:db_insert_placeholder_1] => api_browser_project:packagist_modules/morethanthemes-commerce_product_outofstock_extra-morethanthemes_commerce_product_outofstock_extra [:db_insert_placeholder_2] => O:45:"Drupal\project_browser\ProjectBrowser\Project":20:{s:2:"id";s:135:"api_browser_project:packagist_modules/morethanthemes-commerce_product_outofstock_extra-morethanthemes_commerce_product_outofstock_extra";s:4:"type";E:41:"Drupal\project_browser\ProjectType:Module";s:4:"logo";a:2:{s:4:"file";a:2:{s:3:"uri";s:57:"https://juno.ioc.ddev.site/core/misc/logo/drupal-logo.svg";s:8:"resource";s:5:"image";}s:3:"alt";s:33:"commerce_product_outofstock_extra";}s:12:"isCompatible";b:1;s:12:"isMaintained";b:1;s:9:"isCovered";b:0;s:8:"isActive";b:1;s:13:"starUserCount";i:1;s:17:"projectUsageTotal";i:1123;s:11:"machineName";s:48:"morethanthemes_commerce_product_outofstock_extra";s:51:"Drupal\project_browser\ProjectBrowser\Projectbody";a:2:{s:7:"summary";s:63:"UX fixes for the out-of-stock functionality of Drupal Commerce.";s:5:"value";s:63:"UX fixes for the out-of-stock functionality of Drupal Commerce.";}s:5:"title";s:33:"commerce_product_outofstock_extra";s:7:"changed";i:0;s:7:"created";i:0;s:6:"author";a:0:{}s:11:"packageName";s:48:"morethanthemes/commerce_product_outofstock_extra";s:3:"url";s:67:"https://github.com/morethanthemes/commerce_product_outofstock_extra";s:10:"categories";a:0:{}s:6:"images";a:0:{}s:8:"warnings";a:0:{}} ) in Drupal\Core\KeyValueStore\DatabaseStorage->doSetIfNotExists() (line 179 of /var/www/html/web/core/lib/Drupal/Core/KeyValueStore/DatabaseStorage.php).

Recipes returned:

Drupal\Component\Serialization\Exception\InvalidDataTypeException: You cannot define a sequence item when in a mapping at line 22 (near "- ckeditor_accordion # TODO CSS"). in Drupal\Component\Serialization\Yaml::decode() (line 43 of /var/www/html/web/core/lib/Drupal/Component/Serialization/Yaml.php).