Useful or not. People bring ornot. Honestly, I'm not sure how other people's reply can help you in any ways.
Ultimately. It depends on you.
Depends on what you going to shoot, your style, your trip and etc. If you know you will use it. Bring it. If you're unsure. You can choose to keep it at home or bring it - if not bringing it along is bothering you.
Many people will tell you. Gear are only useful if you use them. No matter how good they are. If you are'nt using it. They are as good as "useless"
Depends on what kind of holiday right... If you like to shoot macro, and you're travelling to south america to shoot insects and plants... obviously you would bring it. Family holiday to a beach resort where I know I'm going to be spending most of my time either lazing on the beach or in the room, very unlikely.
To this kind of "Should I bring it?" question, my usual answer is that there's no other better way to find out than to just bring it along for one trip. If you don't bring it, you might be stuck there and wondering 'I wish I brought it'. I'd rather regret bringing it, cos you still have the option to leave it in the room.
After this trip, you will know the answer for yourself because nobody knows what you like to shoot or intend to do on your trip. You will know what to do for future trips.
If I am going on holiday to take pictures of macro subjects, of course I will bring a macro lens. But when on holiday I like to keep weight as low as possible, so that means a travel zoom. For me travel zoom means either 12-40 or 14-150, since I use an EM-5. Switching between a tele and a zoom isnt what I would like to do on holiday. After all, we should enjoy the holiday, and not let the camera or number of lenses dictate the fun we should be having.
I carried my iphone and maybe my Canon G7X on outing. Unless I specifically planned that holiday trip to be a photography trip. Anyway, different people had different preference, so ultimately it is up to yourself.
I can understand why you are tempted to bring a macro lens overseas. I'm an advocate of macro lenses, believing every photographer should own one. Macro lenses provides a perspective unlike any other lenses, and could potentially give you unique holiday images that sets you apart from all the photos you see on Facebook.
However, I do not recommend that you bring a macro lens overseas. The only reason to bring them is if you are an insect, toy, or flower photographer. But if you are an insect, toy or flower photographer, there wont even be this question in the first place. So as a shoot everything hobbyist, you are better off bringing a standard telephoto zoom like the 55-200 than a macro lens. You will probably miss more holiday shots if u use a macro than a 55-200.