Oooo, that looks intriguing! I assume your using a tripod and a reflector!? If you do a lot of this then I really would recommend a Digital SLR camera body and a dedicated 1:1 macro lens, they all have automatic point and shoot modes too. Though, even second hand it would probably be over budget....
Looking at the spec of your old camera, it had a 1cm macro mode, so this should probably be the main thing to look at. You may as well stick with Canon, according to the spec I've found, the Canon IXUS 265 HS has a 1cm macro....