First off, I've searched through threads in this forum for other people asking for similar advice. And based on what I've read so far, it seems that the suggestion right for me would be a Sirui 2204X and K-30x ball head. The issue is that I'm not really sure why these would be right for me, aside from seeing them come up the most often in advice to other posters.
I've got a 70D with a grip, and 100mm macro/canon24-105L as the biggest/heaviest lenses.
Primary use case will be doing indoor product shots and macro shots (stationary objects).
It seems that the K-30x is recommended because of the weight of the camera/grip/lens. However I'm less sure about the 2204x. There's also a non-x model (the 2204) which is slightly more expensive on various retailers - but I couldn't find any info on 2204 vs 2204x. Also read some people comparing "spike" vs "non-spike" version of the tripods, but not sure what model that is.
The 2204x is $310, and the k-30x is around $135. That's just under $500 for both - if there's a better option within the same or smaller price range for me needs, I'd love to know more about recommended options.
I will NOT be bringing it on mountain hikes or into marshes or anything. The most "outdoors" I think it would ever get used, would be on slightly uneven grass/gravel to get landscape shots or the occasional outdoor portrait. Point being, the weight and ability to setup on uneven terrain are not major concerns.
p.s. the last tripod I had was a ~$60 aluminum knockoff that looks similar to what "AmazonBasics 60in tripod" now sells for ~$30. It broke and honestly was never very good - would tip over with my 70d+grip+lens all the time.