The Macro shooting mode of many Canon cameras works well, but for more creative close-up shooting with enthusiast-level cameras, it's best to take control yourself. The use of semi-automatic and manual modes can pay dividends.
A particular challenge is that depth of field (the distance between the nearest and furthest points in a scene that are rendered sharply) becomes very small in close-up photography and absolutely tiny in full macro shooting. To maximise the depth of field, you can switch to Av (Aperture priority) shooting mode and dial in a narrow aperture of around f/16 to f/22. Unless lighting is very bright, however, this can require slow shutter speeds for a correct exposure. That's not generally an issue if you're using a tripod for flower macro photography, food close-ups and other still-life subjects, but dull lighting can result in flat-looking images. For indoor shots, you can add light with a table lamp, or use daylight from a window. Photographic LED lamps are also a good option, as are the LED Macro Lites in some Canon lenses, mentioned above.
Insect macro photography will require a fast shutter speed to freeze the motion. This is also true when other living subjects are involved, for example in eye macro photography. One way of achieving this when also using a narrow aperture is to increase your camera's ISO setting. However, going for a higher ISO can result in a loss of fine detail and an increase in image noise – which is where the low noise capabilities of full-frame cameras like the EOS RP or EOS R6 come into play.
A more advanced solution is to use a flashgun or Speedlite. As well as adding illumination, the very short duration of the flash effectively freezes the action. For ultimate close-up control and a shadowless lighting effect in macro photography, the Canon Macro Ring Lite MR-14EX II is compatible with most Canon macro lenses.