I am sure it'll be a few years as manufacturers will worry that a future admin (if we get such a thing lol) could un-remove the fees - but it would be wonderful to see actual small trucks again.

CAFE wasn't 'dumb', it was designed to prevent the 'big three' from manufacturing (new generations of) small cars outside the USA (i.e. in Mexico), with non-UAW labor. CAFE was not designed to protect the environment or reduce emissions; that was just a PR veneer to make it more palatable. You're completely correct that it led to strange designs, perhaps most notably the PT Cruiser (which was classified as a truck https://en.wikipedia.org/wiki/Chrysler_PT_Cruiser).