Getting very close allows you to see things you don't normally see, so it tends be really interesting. In nature work, flowers and insects become entirely different subjects when you get very close, approaching life size or larger. If you search Flickr for macro you find mostly flowers and insects, no surprise.
In macro work, depth of field gets very narrow, and for more depth of field, you need more light or higher ISO. Plus you often block your own light and you scare off the insects. If you get frustrated with close-up work, welcome to the club. Get a book or a teaching video on macro work.
Bottom Line: Close-up photography reveals levels of detail that we don't normally see, so there is automatic interest generated by shooting very close. But shooting close has many technical issues you will need to deal with.
Confession: I decided very early to use one subject — Nicole — for every shot. I think it was a good idea, and adds more to the project than it takes away, but people are really NOT the ideal way to show what a macro lens can do. So I added a supporting sequence with a vase of flowers. I can't think of any human body part, other than the eye, that becomes more attractive as you get closer.
Nicole: f8, studio flash, 100mm macro
Flowers: f8, studio flash, 100mm macro