I could have used the manual mode. But I used a mode that let me shoot in macro mode which probably is available in manual as well. I wish this camera had super macro mode.
You may be able to get diopters to attach to the lens.
I know you say you don't need a DSLR, but this is one of many, many benefits. A lot of interchangeable zoom lenses have a close focus mode(maybe not true Macro). Furthermore, there are purpose built macro lenses that-for modern ones-typically will focus as close as "lifesize", or in other words the subject is reproduced on the film/sensor the same size as it is in life(which means a super close up when you enlarge it to a normal photograph size).
You can also "cheat" by using inexpensive devices like extension tubes on normal prime lenses, or use tubes on macro lenses to get even more magnification.
Macro is a field you can get seriously deep in and it's a whole new world even for a lot of experienced photographers who have never done it. Still, though, it's INCREDIBLY satisfying to do right and opens up a whole new world. Even mundane objects around your house can be fascinating subjects.
Here's one from a presentation I put together for a presentation at the local photo club last spring right before everything went to heck. This one was pulling all the tricks-a 55mm f/3.5 non-AI compensating aperture Micro-Nikkor(one of my favorite Macro lenses, and I explained why it's still my favorite in my presentation despite it being a 1960s design and production lens) reversed on a set of Nikon PB-4 bellows(old but IMO the best they have made). This was shot with a D700, which is now a relatively old camera.