What solder to use on basic automotive wiring?

As far as soldering your wire connections, I would advise against it. Use some good terminals and a decent set of crimpers and you'll have great results! Soldered connections, as far as I know, are not used in any vehicle from the factory. That goes for RV's as well.
I stopped soldering connectors in my race cars after a few broke off right outside of the connector; as noted, the solder will tend to wick out into the wire strands, and create a stiff area right there near the end of the wicked solder. All the weight of the wire under vibration will concentrate there and tend to anneal over a period of time, and then break. If you do solder, then it is wise to make sure the wires are well supported a few inches beyond the solder point.