There are three specs that matter. (4wd matters in the hills, since it is surprisingly easy to get stuck on pavement/gravel when going uphill under load, but that is orthogonal).
The three things are bed capacity, max bed weight load, and towing capacity.
Weight in bed can matter, but once you’re above a few thousand pounds, you need to consider getting a dump trailer. Max carrying load matters more for conversions (e.g. to ambulances, adding toolboxes, etc). Towing matters for moving lots of weight.
In the cheap 150/1500 ICE class, Ford wins these days on bed capacity (3000lbs), due to having aluminum frames. Ram wins at towing capacity (10,000lbs).
As much as I like dunking the cybertruck for its impractical bed and Musk’s shenanigans, it can tow 14,000lbs, making it best in class for quarter ton trucks (assuming you count it in the same class as the ford F150 lightning).
So, I’d like one for driving to and from our local rockery, except that using it for that will beat it to hell, and a used truck + nice EV sedan will cost less, be more fun to drive, and win on total CO2 emissions. The sedan uses much less electricity than the cybertruck, and would be driven many more miles than the truck. I’d only put a few tanks of diesel into the truck per year.
Eventually, the grid will be more decarbonized, and batteries won’t be scarce. At that point, the cybertruck would probably be a better choice for me.
Source: We bought a 1500 truck that is slightly too small for our use cases.