IMHO, we should simplify that down to something trivial based on the
SMART status + a wearout indicator for flash.

That’d be a good place to start.  Drive mfgs and smartmontools’ drivedb.h are all over the map wrt attribute IDs and labels - and in some cases even used vs remaining - so we might need to have a regexp sort of match for SAS/SATA drives.  NVMe should be a bit more standardized.