Hi all, I would say I'm a decent-ish diver but at the newer end of the spectrum (AOW w/~60 dives in tropics, temperate and coldwater/drysuit, majority in past 2 years). I did my OW in Indonesia (Pulau Weh) in 2011 then didn't dive for years, but have been dreaming of going back to Indo. So, next month I head back for a one month dive trip, from mid-Sept to mid-Oct!
Have you not dived in the past 2 years? You might consider taking a refresher course.
Are you nitrox certified?
I was aware when booking that R4 (and the rest of Indo for that matter!) can have extremely strong currents, which made me hesitant as to whether I was experienced enough as, apart from a couple of drift dives off Vancouver Island (Canada) and one dive we had to call early in La Paz (Mexico), I have limited experience with currents. I got reassurance from SJ and R4 dive shops
The dive operations want your booking and your money, so, of course, they will tell you that you will be fine.
and bit the bullet and have been SO excited, but then found myself going down SB and reddit "here is my terrifying downcurrent experience" threads and am wondering if I will be way out of my depth (haha pun not intended)? I also got luckily mild skin DCS early last year (no reason, got cleared to dive again) and have been diving conservatively, but it's made me a bit more nervous.
I don't think it's scientifically proven, but using nitrox has been suggested to decrease your risk of DCS.
I have read key tips like swim perpendicular to the current/shelter in the reef/currents worse at full and new moon etc and have a reef hook, whistle and DSMB, but any other tips to survive and thrive and come back from this trip of a lifetime in one piece would be much appreciated

Sites to avoid? Specific conversations to have with the guides? And/or encouragement that this is not a crazy life choice?
Also purchase a marine GPS, like the Nautilus Lifeline, and bring gloves to protect your hands in case you need to hold onto rocks in a ripping current.
You have good reason to respect and get educated about down currents. During my first trip to RA on a liveaboard, one of our divers died in a down current at a site called Weka's Wow. He had done over 2000 dives, so it can happen to anyone at any time. It was a tragic loss and something I hope to never experience again. This is my trip report.
This is my first trip to Asia and first time to Raja Ampat (RA). I’m going to try to do this as a live report to the extent I have an internet connection. This was a complicated trip to plan and execute because I’m doing a 10-night stay at Sorido Bay Resort (SBR) (as an individual booking) followed by a 12-day liveaboard with Damai II (Bluewater Travel group trip), and I needed to stay within the 30-day visa limit for Indonesia. I did most of the planning myself, but my agent at Bluewater guided me through the process.
Getting to Indonesia. As everyone knows, this...
Let your guides know your concerns and ask a ton of questions about how to get out of a down current. Your guides will also be happy to help you attach your reef hook. As others here have said, pay attention to the briefings and if you're not feeling confident, it's okay to sit it out. Since you're doing land-based stays in RA, you'll most likely go to sites that the operator is very familiar with as opposed to a liveaboard that visits sites that day boats can't reach.
Enjoy your trip and post your experience upon your return.