A proper Western Union splice is soldered, and I use dual wall shrink tube that has hot melt adhesive on the inside.
I also have many different splices, all using various types of connections and shrink tubing, that are watertight.
As a test example, I have solid conductor out of a piece of NM crimped to male and female 1/4" spade connectors, no solder, and covered with my latest discovery of affordable dual wall tubing. It's rock solid and completely waterproof. I have been making waterproof connections for nearly 40 years.
In order to test the shrink tubing, I make the mechanical connections in various ways. Twist, solder, crimp, plug, with and without friction tape, vinyl tape, etc., and then see how much integrity the tubing adds to the splice. The stuff I am getting now is amazing.
Since you brought up hot melt, I will share one of my tricks. If splicing many wires, so that more than one will exit the tubing, adding hot melt where the wires will exit fills in the voids and also adds strain relief. Most people totally ignore strain relief when making up splices.