I have the lensbaby composer. It's fun... but the potential to over use the effect is definitely there. And I will tell you... it is the hardest lens in my bag to use in terms of getting that shot perfect. I never feel like my shots are 100% crisp. So it's sat in my bag a good majority of the summer unused which is sad. I got it back in January and I took an evening while in Las Vegas just to play with it a bit. Here are some of the (few) shots that turned out.
If you want a macro, I suggest getting a macro and skipping the lensbaby w/macro attachment. I have a small 60mm macro which does me perfectly for the type of work I need to do. It was cheap, about $400-$500 and it has sharp sharp sharp shots that I just don't get with the lensbaby. Lensbaby is fun for different shots though.