Will there be any side effects if I get Botox between my eyebrows?

Now that I'm in my 40s, I feel like my wrinkles are getting deeper, perhaps due to my habit of tensing my eyebrows, so I am considering Botox.

People around me say that the satisfaction level is high once you get it, but I'm worried about whether there might be any side effects.

I am a little hesitant because I heard that it can make your facial expression look awkward or make your eyes look heavy.

If anyone has received Botox between the eyebrows, please share your honest review regarding how long the effects last, whether the pain is bearable, and whether you experienced any side effects.