Struggling to decide to elope or have a small wedding w/ family

Hi everyone!
My name is Katlyn. My fiancé and I have been engaged for 7 years, together 9. We have been busy the last few years and have been happy to wait for our big day. We were 17 years old when we started dating now 26. This past year we have been discussing wedding details. We both have been bouncing around the idea if it would be better to have a destination wedding with just us two or a small wedding with family and friends. The hardest part about this, is that both of our immediate family members are difficult. My parents just divorced a year ago and are not on good terms. My younger brothers and I talk occasionally but aren’t super close. My fiancé’s mom is deceased and his father is an alcoholic. Aside from that, some of our aunts and uncles and grandparents are the high light of our life and we really want some family members to be there. I don’t know what to do because there’s a small chunk of them that are going to be negative the whole day. That just happens to be our parents and siblings. ☹️ I can tell my fiancé is having a hard time thinking about this and I am as well. We are paying 100% for wedding. Part of me wants to just have it be us and the other makes me feel bad because I’m the only daughter and probably the only wedding my parents would be able to experience. If there is any advice anyone can give me to help me go about this in a positive/mature way. Please help. Thank you so much.
Katlyn ❤️