1/4 and 3/8 drive sockets, on their own, are for boys (and girls) with little toys. Together with 1/2 and/or 3/4 drives, the smaller sockets are good where access is limited. A larger drive will work on a smaller fixing, but not so likely the other way round.
The only limit is the weight and/or volume for the larger items.
I doubt there are many fixings larger than 3/4” AF on most cars. (OK, there are 44mm,or 47mm, nuts on the halfshafts/wheel bearings of morris minors!).
I am kitted out with 1/4, 1/2, 3/4 and 1” drives. But I would not be carrying them around, in a car, all the time.
A 12 volt lightweight rattle gun might be the answer for roadside use. Ratchet rings and open enders are always useful for restricted access. As an aside, Landrover nuts and bolts required different sized spanners, so spanners need not be duplicated. Spanner kits had different sizes at each end of the spanner, so there were always two spanners with the same jaw size. Not so, with the more moden ring, with open end, combination spanners. Open enders ( of some form) are always needed for brake pipes.
For a set of spanners, for a specific car, it cannot be too difficult to colour code sockets or spanners, I would have thought? Don’t forget the lead lamp, or wind-up torch for night time repairs.