I agree very much about the weeds. For several years I've been concentrating on my kids' sport, mainly surf lifesaving and flat water kayaking. But not much happening over winter, so I went looking for other subjects - and realised, like you, that common weeds are often surprisingly beautiful if you get in close.
I started off doing it manually but came across the Stackshot from Cognisys, which is a small hand-held computer controlling a motor-driven rail. Attach your camera to the top, punch in your favourite settings and away you go. Excellent piece of gear. It was so easy I started off with ridiculous numbers of photos - up to 100! - but soon learned far less were necessary.
A firm tripod is vital and I strongly recommend a geared head, not a ballhead. This was advice gained from this forum.
I've posted a series of stacks on Smugmug if you care to look; nearly all of weeds a few meters from my front door: