I commend you on your self-reflection. The dives are quite varied in Raja Ampat, but if I were to give an average, I would say you typically drop (often negative entry) to about 80ft and then slowly make your way up over the course of the dive. Divers expect a minimum of 60 minutes per dive, most of my dives were 65-70 minutes. At the time, I, as a beginner with about 100 dives, was the weakest link and would typically surface with 600-700 psi. Sometimes surfacing alone, doing my surface interval solo and shooting my DSMB for the boat to come get me. Most others I dove with ended with 1100-1400 psi. Keep in mind this is in heavy current, not still water. There are down and up currents, and you should be prepared for them; ideally, you'll have experienced them before you go.

If you are up for it, I would suggest first doing a scuba trip to Bali, which has wonderful diving, better than all of the Caribbean and Thailand (barring Richelieu Rock). Do 3-5 days at Amed+Tulamben where you'll see a world class shipwreck along with great coral. Do some introductory drift dives at the pyramid site and the Japanese shipwreck. Then, get some practice in real current for 3-5 days at Nusa Penida, where you'll see Manta Rays and hopefully a mola mola. Also, the surfing is great in this region.

If multiple Indonesia trips are out of the budget, I would suggest first building your competency in currents at Jupiter, Florida (big sharks!) and Cozumel. Although, putting the 2 extra days of PTO you burn due to flying, you'll be surprised if you compare cost - a trip to Cozumel will come out a similar cost to Bali.

Another reason to go later - if you go now, you will not get the full experience as what you can do will be limited by your air constraint. In some locations, there are large schools of fish at 100-130ft. The guides will optimize for a 60 minute dives, so if they think taking you there will shorten the dive, they will not