upgrading the alternator with a standard system and no changes otherwise may have benefits such as
improved battery charging
maybe a tiny tiny bit brighter headlights and interior lighting
radio may sound slightly more crisp (questionable)
maybe less dimming when the brake pedal is applied.
ac fan might have a smidge more kick
engine "may" maybe run tiny bit better, nothing you would probably ever notice but could perhaps show up on a oscilloscope.
perhaps a .000004 hp increase from less alternator strain
that's really about it, battery health plays a big part in all of that.
No, none of that. You're just guessing. That would require the tiniest battery and undersized alternator with additional loads that are too much for the stock electrical.
Electrical/THE LOADS, are a pull (what they need, not a push from the battery).
OP
The factory cable from alt to batt + is a fusible link. It is sized for the factory size alternator. If it has too much amperage/resistance then it is designed so that it will burn and break inside the casing, but the case/sheathing will stay intact, in order to prevent a bare wire from connecting off the amp to metal, arcing, and burning your pickup to the ground.
If you're going to upgrade your alt to something larger, you would need to upgrade the charging cable to get the benefit. You would then fuse that cable, and you would want a protected fuse holder.
The cable can be as large as you want. The fuse on the cable, needs to be less than the cable's capability. The point of the fuse is to intentionally create a weak point, that can be controlled, and easily fixed.
I'm mostly pickups, but there are two sizes of alternators, 105 and 130. 105 is a small case, and 130 is the large case. The 130 large case is also, 145, 160, 180, and just about everything else aftermarket. The shape of the two alts are different, and the pulley is in a different spot. The large case uses a serpentine belt that is 3/4" longer than the 105 amp small case. The smaller belt will physically install, on the larger case alt, but will cause more pressure on the alternator, and leads to: hard starting, whining at higher rpm, belt slipping at higher rpm, and poor charging issues. THIS is really why you need to know which alt you have. Personally, you should take the time to find the part number on the belt, and if you wanted, you could always see how to test the output on the alt if you didn't buy it, or own the vehicle since new.
105 came on 99-04, and then in 05 they went from clutch fan to electric fans, and needed a larger 130 amp alt, (might be a little higher on SUVs, the 3 digit K code in the glove box should be your alt size). If you are having bearing noises from the alt, someone may have previously upgraded the alt and not the belt. Replacing the belt to the correct size might solve your problem and be cheaper.
Unless you have aftermarket amps for subs, or have larger draw items in your vehicle like a fridge, or a pump, there's almost no other reason to need a larger alt than factory. If you're not getting voltage drops, then you have all you need.