There are a lot of good comments here. Ultimately for portable work—hard portable work—you realistically are probably looking at RG-174 For HF at least some of the time. I was down on it initially and questioned why SotaBeams used it on the band hopper, but Richard knows his stuff and I came around. It is much smaller, much lighter, and easy to use. There is definitely more loss and it is more fragile as noted by others. I have pulled a BNC connector off the end when rolling it up. But for strenuous hikes and QRP operation for no more than 14 MHz I will sacrifice a bit more loss at the practical lengths For the benefits. The weight and size of larger cable just are not worth it on many hikes and on a few it is not safe Adding imbalance or bulk when climbing.
If I am trying to get all the signal possible, go with a larger cable, maybe even RG-8x. Larger would be much more inconvenient. I personally would never use RG-174 for 2 meter or higher frequency no matter how short due to loss.
The truth is, you will probably end up with a variety of antennas and choose which to take based on the factors of your particular activation. My primary antenna for this last Field Day has a problem During the event. I had some backups but for convenience of putting up only one more antenna I raised the BandHopper in the tree for 20/40 and continued on with QRP.