So my question is, will there ever get a technology that you can recover your bitcoin from when you have been scammed.
This is the simple question that Op asked, I think we are thinking the question to be a mistaken transaction that you can immediately recall. I understand he is asking if the bitcoin has been confirmed in Blockchain be it many years ago (I think that is the literal meaning of the question). My answer is
No. If your Bitcoin has gone to another wallet and confirmed either by mistake or scam, there it shall remain by God's grace

except you are able to plead with such person if you know the person or police is able to track the person and by duress get the person to retransfer it. Apart from that, a lost btc remains lost and I don't think Blockchain has a machanism to begin to reallocate the bitcoin back to whichever wallet after years.
A practical example is with fiat that is with the bank. Bank can't withdraw money that has been used which is mistakenly sent out. They can trace the money to the account where it is sent and probably flag it as scam account or fraud until they recover the money. I think that can be linked to bitcoin or Blockchain.
In my opinion, it can help many people that lost their bitcoin for the long term and appreciate the value more than before.
Yes it will help but I don't think it is possible. If it is possible then we can as well use same technology to "steal" other people's coins in their wallet. If it were possible then we can also get same device to pull out billions of dollars from world bank.