When I first got the Tamron 90mm lens of course it was time to play. and spend lots of time learning. I have several tripods. One is a heavy duty tripod for when I’m using the 100-650 lens, and then at the oppose end of the spectrum, I have a lightweight tripod that folds up neatly to fit into my camera bag. I usually carry this one with me so I have something to work with, and it can hold my 18-400mm lens in a pinch as long as I’m steadying the frame. But mostly, I use the lightweight for macro work and getting close to the ground, or as in this instance, close to the bee as its collecting pollen.
Found a great buy on a trip last spring. Five dollars and I have found it to be about the best tripod that can handle from the heavy lens to the lightweight, and not an onorously heavy tripod. Older, but by golly it gets the job done. It isn’t about the cost of the tripod, in the end, it’s about what works for you as the photographer. This I have found to be true.