Any will do, preferably leaded, preferably the more rosin-bearing not-no-clean kinds. 60/40 is cheaper, and the case can probably be made that it dilutes slightly with pin/lead plating (usually tin) or when working with mixed (lead-free) joints as in repair, getting closer to eutectic in the process. Well, that probably doesn't actually happen to a meaningful degree, with how thin most platings are, and how much solder you'll use by hand, but it's fun to think about I guess?

63/37 is just a little nicer to use, but does cost a premium. Silver bearing is stronger, but costs more still. As mentioned, there are places where it may be required.
Thinner wire is also recommended, but it depends on what you're doing. If you're doing mostly chassis repair (vintage terminal strips and stuff), thicker is good. Thinner is easier to use on PCBs, especially with fine SMTs around.
You can always get multiple kinds, too! You'll most likely lose the opportunity for a bulk discount that way, but it won't be as expensive as, say, straight doubling your order.
Or maybe you find a good deal on something anyway and just go with it. I picked up something like 3 lbs (~1.36kg) 63/37 no-clean a bunch of years ago, for like half retail price, and I'm just now finishing up the last roll of it.
The only thing to absolutely avoid is acid-core, or some strongly-activated rosins (but I think none are as bad as acid-core per se?). Everything else is some permutation of technique, temperature (get a reasonable temperature-controlled iron, like WESD51 or similar; use it at different temperatures, see how soldering performance is versus how quickly the tip fouls / flux chars, find a balance; also turn it down when not in use, greatly saves tip life!), or just using paste/gel flux on top of everything!
True for lead-free as well: leaded is easier to work with, lower melting, smoother deposit generally; but lead-free is not much of a challenge to use, just get suitable fluxes for it -- the higher working temp tends to char, evaporate and use up rosin-based types pretty quickly. Both are fine with practice, lead-free just takes a bit more practice.
Tim