I totally understand the frustration. Been there, done that. I went to an RV show and found what I thought was quite a good selection of trailers within the "tow capacity", of a 1/2 ton pickup. I thought.. Hey, great,.. lots of trailers that fit within the max trailer weight rating, and within the GCWR (truck and trailer). Found a killer deal on a used pickup (Sierra 1500).. bought it. Then HOLY ****.. I forgot about Cargo Capacity. DADGUMIT. All of a sudden the trailers that I was looking at put me unconfortably close to the GVWR of the truck. I didn't want to get right up to the edge. Dang near sold the pickup until I found the trailer I have today. The numbers worked, so it worked. BUT, not without a lot of frustration and almost giving up on the truck.
So, I learned that day, that I should have settled on the Trailer first, then found a truck to tow it. In the end, I think you'll find a combo that works for you, but I do understand the frustration.
Mike