Yes, it does matter how you load addons, but it only matters if you care about the results
Regarding CBA, it no longer is important to load CBA as last mod, the config (I think its there) has a built in check so its always loading last or in a different way but it is checking itself its contents are overwritting/loading last.
As for other mods, if different mods/addons change the same aspect of the game it matters which you activate last.
If for example 2 soundmods change the same sounds but you prefer the sound of one of them make sure to load that one last so it will overwirte the same sound of the other soundmod.
It comes down to testing yourself and comparing the result(s).