If you have a cheap point and shoot digicam, you can still turn it into a good macro camera with the help of a small 10X or 15X magnifying glass. These magnifying glasses are small...the kind that is used by watchmakers or jewelers, and even hobbyists to examine stamps and coins. Attach the magnifier to the front of your camera (but DO NOT touch the camera lens) with some blutack, optically zoom your camera in as much as you can to omit the dark ring of the magnifying glass from your frame, and voila!
The magnification is awesome, but the depth of field becomes very shallow and the distance you have to be from your subject is going to be quite small. I took these photos with such a magnifying glass mounted over the front of my old Canon PowerShot A40: