I had this same dilemma when we bought our house two years ago. We were needing a vehicle anyways so I ended up taking advantage of the cheap lease deals on a 2018 Tacoma double cab long bed (6ft).
Since we've done some major remodeling on our house (kitchen/bathroom/garage/siding, etc.) it's been incredibly handy to have around. As others have said, it's a game changer for many reasons, however, one the lease is up I doubt another *nice* truck is in my future. It's still a newer very expensive vehicle that I constantly worry about damaging due to what we've used it for which kind of defeats the purpose of a truck IMO.
A cheaper used truck would be ideal but after factoring in operating costs of owning an extra vehicle it's probably cheaper just have everything delivered or rent the HD trucks when needed.