As someone who only wants to occasionally perform one-off firmware flashes on my devices, soldering always felt clumsy and heavy-weight.
For actual chips, SPI programmer clips have been great. For test pads, I just ordered one of these [1], which will hopefully work just a well.