I've never used loctite solder, but I've had excellent luck with Kester or alphametals. I don't see smaller spools than 1 lb on digikey, but they have an excellent spec sheet. Personally, 8oz spools are a good size where they aren't too heavy or bulky, but that's personal preference. Additionally, 0.032" is for me a nice balance where you can still do SMT (id say 0603 is ideal, 0402 can be done but for that I'd recommend smaller) but you can still solder larger stuff, up to around 14AWG wire.

https://www.digikey.com/en/products/detail/kester-solder/24-...