For macro photography, I have an aluminium Manfrotto tripod with the arm permanently mounted horizontally. I have a pistol grip head on it but I find it annoying - too tight and it is hard to move smoothly and too loose and it doesn't stay in position.

Can someone recommend a tripod head that would work really well with this tripod for macro photography (Canon 5D iii camera and 100 mm macro lens)?

Or, is there a tripod and head combination that is just the bee's knees for macro photography? Flowers, wee mushrooms, etc.

Thanks.