I've tried most hormonal contraception & all affected my sex life negatively in varying degrees. i'm considering a long term bc, preferably affordable and easy/relatively painless to insert ie implant but i'm worried it will also affect me badly?

Pregnancy protection: I suggest that you start by reading about the many different options you have if you don't want oral contraceptives. See what looks like it might fit into your life. Next, you can talk to your physician about which would work well for you. Good luck

Consider copper IUD: The copper IUD is non-hormonal & works locally (in the uterus) to prevent pregnancy. It is a long term solution with minimal maintenance. Initial insertion is uncomfortable but afterwards you are free to live life as you wish, with no hormonal side effects. Discuss this with your doc & consider it a possibility.