It depends what your budget is, and to be honest I would start off with a macro hack to see if you get on. Macro always sounds appealing to start with, but it there isn't always opportunity to take it up; so my recommendation, invest in a 2nd hand nifty 50 (Canon's 50mm f1.8). Cheap as chips, especially second hand. Add a reverse ring and some extension tubes. You can combine them together or just try one or the other first to see how you get on. You can actually get some good results with this setup.
Some info on these here for example (just google reverse ring and extension tubes macro).
http://www.slrlounge.com/extension-tubes-reversing-rings-cheap-macro-accessories-reviewed/
Tthis was taken with the reverse ring and extension tubes.
Lily Anther by
Andrew Young, on Flickr
This was taken with a reverse ring and the 50mm
Sleepy Snail by
Andrew Young, on Flickr
Not great shots but give you an idea of what you can expect
Another nice hack is to get a black tube with a plastic diffuser on the end (I used a piece from a milk bottle) to carry the light from the inbuilt flash to the end of the lens. Attach it with elastic bands. It gives you a bit of flash for your subject, you can then user higher f/stops and get a bit more DOF. I'll take a pic of one I put together if you want so you get the idea. I took inspiration from this
http://www.monkeyonabicycle.com/2010/10/diy-macro-photography-iv-on-board-flash.html but made one much smaller and compact than that one
After this if you do think you will take it up, then it's time to consider something like the Canon 100L, I picked one up second hand (IS version) for £440 some time ago.