Welcome back
With a 100mm macro lens, you don't have to go far. I do a lot of macro/close up work from the comfort of my house. And if I'm feeling adventurous, I'll go out to the yard, LOL! Weather is never an issue when shooting macro, nor is time of day. And you can pretty much shoot anything. I'm always grabbing flowers from the supermarket to shoot. That's always fun.
As mentioned above by DW58, if you're going to do macro/close up work, definitely invest in a tripod. I'd look for one that allows for a lot of flexibility like the Manfrotto 190XPRO or a Vangard Alta Pro.
I have an older Manfrotto 190XPROB with an Acratech Ultimate Ball Head. Great for macro work, can pretty much move the camera where I want it.
There are some great videos on Youtube for macro idea generation. And of course Naas (a PF member) has an excellent extreme macro site that is worth checking out.
Extreme Macro Photography
Looking forward to seeing your work.