While sales of mid-size and large vehicles took a slight tumble in 2024, many of the auto industry's smaller offerings saw a boost.