To be honest, those auto modes are quite gimmicky, not magical modes that transform the camera into a macro or landscape capturing machine.
You can emulate all the modes with the particular settings each mode has been pre-set to (I believe they may be indicated in the camera manual). The problem with them is that they are still all auto modes with no ability to manually override the exposure settings the camera decides on to capture the scene in front of it.
If you want more control over your exposure settings (aperture, shutter speed, sensitivity), then I'd suggest going to the mode which will give you the control you want.
e.g. Av mode if you want direct control over aperture, but are not overly concerned about shutter speed.
I recall a "Sunset" mode on my old K100D, which apparently deepened the reds and oranges in the image but apart from that quite an unimportant scene mode. All my fine adjustments are best done in post-processing, and that is after I've converted all images from RAW to JPEG.
Hope this helps.
PS. I believe Kevin means "smallest aperture possible to maximise DoF" in macro mode - a high aperture number is a small aperture.