Personally I don't quite agree with the message of generational curse as its not totally biblical or logical.
BIBLICAL CONTEXT OF GENERATIONAL CURSES
Sure, you can quote Exodus 20:5-6, Numbers 14:18 or Deuteronomy 5:9 which mentioned generational curse (which are also the only context where generational curse is mentioned!). But note, it also mentioned generational blessing!
LOGIC OF GENERATIONAL CURSES & BLESSINGS: EACH ANSWER TO THEIR OWN SINS
So the question is if say my great grandparents did something wrong but my grandparents did something right, are future generations to be blessed or cursed? If say all done wrong in eyes of God but in my generation we did what is right, are we to be cursed or blessed? If my ancestors did something right which my generation ought to be blessed but we did what is wrong, are we blessed or ought to be cursed then? So it does not really matter what my ancestors do any more because ultimately it still depends what we do personally!
This is confirmed by Prophet Ezekiel (Ezekiel 18:1-32) that each is to answer their own sin that no other generation shall be made guilty that they shall suffer because of it (Israelites created a proverb complaining generational curse is unfair but God said if future generation does what is right, they will be blessed, not cursed and if that generation sin, regardless of what earlier generation do, they will still be cursed anyway or something like that).
GENERATIONAL CURSE MESSAGES ARE UNHEALTHY?
The so-called 'generational curse' may just be a social influence rather than like something inherited. If parents smoke, there is a higher tendency for the children to observe and following thinking its cool or its normal to smoke that if you don't want yourself to be out of place. Of course, there can be bad genes inherited but this probably has nothing to do with curse. Even good people can inherit bad genes.
Why am I against generational curse messages? Most parents love their children dearly. If something undesirable happen to their children, parents may attribute it to themselves as something bad they have done that led to their children suffering this or that. Why put parents into unnecessary pain and heartache? Sure, you can say pray for deliverance but what if its not a curse as you claimed it to be and the prayer does not help? Many will be quick to say "ahhh... cause the parent is not sincere enough" then it will just lead to even more attribution of fault to self (the parents) causing even more unnecessary pain. Is such practice of Christianity healthy or even biblical in the first place? Instead of saying prayer for deliverance from generational curse, label it as prayer for miracle, for solution to a problem. Sometimes there is too much fundamental attribution error in churches and very rigid judgment made that if anything wrong, it must be the person's fault as if no other causes can exist. This is very easy to occur because you cannot really tell if something is a curse as its not something observable. You can only see the problem but hard to identify the real cause! Also, remember Jesus corrected his disciples of this fundamental attribution error (John 9:1-3)?
Instead of blaming yourself for problems your future generation may face, correct your ways and if corrected, stop blaming yourself as you should no longer be faulted if repentance is there. Should future generation suffer anything, problem may just be created by themselves! That problem may not be caused by you or themselves but other social influence or genetics influence that you do not have full control over also! So instead of finding someone or something to blame, teach future generation righteousness and guide them to it! Wouldn't such positive message be even better?