Hi OP
Interesting holidays is something I missed the most when we had kids. And the truth is, until they're around 4 or 5, wherever you go on holiday (uk, short haul beach holiday or whatever) will be completely hard work and sometimes not feel worth it when they're not sleeping because they're out of their routine and bored because they've not got their normal toys and you're having to eat in mcdonalds because they refuse to touch any of the local interesting food
Mine are 6 and 9 now and sometimes we have amazing holidays (we went to Spain this year and visited some amazing towns, mountains, went kayaking etc and have had some cool city breaks) although it's a bit heartbreaking when they don't like the same things as you (think our skiing days are over which I've not yet come to terms with) or you take them somewhere objectively amazing like Rome and they just moan its too hot. I've had friends with similar age kids go hiking holidays, Barbados, Japan, tour South America even so it can be done, although the ones that have done it successfully are very strict on behaviour all the time (no screens, calm voices at all times, no pestering, no junk food etc), which means when they are in the rainforest for a week with nothing to do they don't get bored.
I think there are other aspects of parenting that are worse. Like the lack of any time to yourself. The absolute relentnessness and repetitiveness of it all in the early years with no escape. The way they nag and moan and make you angrier than you've ever been in your life. The constant nursery illnesses for the first couple of years. The constant battle between work and home if you have a career. The sexism that appears from nowhere at work as soon as you become pregnant. The judgement from other (mainly) mothers as soon as you become pregnant.
There are of course good things. Seeing your child learning, thriving is amazing. Sleepy cuddles where they tell you how fantastic they are and how much they love you. The mind of a 4 year old is a wonderful and fascinating and refreshing thing. Finding new shared hobbies that you enjoy together or rediscovering old ones through them.
Overall the good and the bad balance out for most people.
The one thing that will determine whether you enjoy motherhood above anything else, is the support from your partner. If they take half of the mental load (say deal with school and nursery while you deal with hobbies, organise the food and entertainment for kids parties while you do the guest list, do hair cuts and dentists etc), do half the night wakings, share some of the paternity leave, change their hours as much as you do so you both do nursery runs, arrange with you to take the same time off for hobbies or socialising, so that downtime is equal, take time off work last minute when the baby is sent home from nursery again, shares the housework when youre on maternjty leave rather than expects you to do it all because youre off anyway,..all this tiny mundane stuff will be the stuff that makes the difference between feeling resentful and overwhelmed and trapped, or feeling like you're a successful family unit with mental space to have some fun. So talk all of this stuff through, in detail, before making any decisions. And if he is the type of person who disappears off for weekend long hobbies and doesn't want to give that up, if he is the type of person who has to be nagged into doing any chores and leaves you to organise everything, if he is the type of person who goes to bed for a week with a cold leaving you to do everything, then don't have kids with him.