Buy the Canon A70 or A80. Its about £220 - £300. A70 is 3.1mp / A80 is 4mp. They have fantastic macro modes, lots of manual settings, auto too if you want. It does do short 30 secs 640x480 movies too (which can be handy).
Check my site -
http://petemc.net and I'm sure you'll be sold.
