@Brooothru
I had a " beercano " early in my dry hopping pressure attempts and agree doesn't really seem much point working under pressure and then releasing it. I also only dry hop when necessary and most of my beers don't require it. But when needed I do the bag thing, however the various " sight glass " type dry hoppers are working at the same pressure as the beer or higher to blast the hops in. So I don't think there would be much nucleation issue occurring it's the pressure difference that makes the difference I think. Much like a beer can widget only works when the can is opened or the mintoe in a coke bottle, if you could drop that mintoe in with a sealed coke bottle I don't think you'd get a bottle bomb.
I haven't had a problem of getting the beer to clear when I've dry hopped and I do cold crash and drop out the trub / yeast and hop residue under pressure. I find the hops can still get out of the bags I use so they are in the cone. Some people advocate moving these sunk hops around so they don't just sit at the bottom using CO2 injection from the bottom, shaking or pumps to do this. I can't say whether it's necessary or not.
I don't " drop " the hop bag off the magnet but slide it down, this ensures the hops are submerged and then I can " waft " the hops in the bag around which does stir up the beer and can move any around in the cone.
My end game like yours is if I'm going to the trouble of dry hopping I don't want any oxygen near the beer, I purge the kegs using ferment pressure having filled them with starsan, purge any lines used for transfer and then run ferment gas thru them before disconnecting when they are at my target beer pressure.
I then cold crash and transfer using the pressure which is higher in the receiving kegs to run the transfer. So if the intended vols are 2.3 the pressure might need to be 22.55 at 18 celsius. So at the end of ferment I have 2 kegs at 22.55 psi and the fermenter. Your figure of 15psi and 18 celsius would give 1.8 vols on my calculator.
Disconnect the kegs and then cold crash the beer, the pressure drops say it's 4 celsius then it'll go down to well below 22.5 psi. Then when I transfer keg pressure equalises into the fermenter and the closed siphon pressure transfer occurs. If needs be I use the other keg gas reserve to keep the transfer going.
Picture of keg train below with spunding valve on the end of the train.
This does mean the beer that goes into the keg is at the correct vols straightaway and is clear ( though not if hazy!) , maturing/ development can occur in the keg fridge whilst it's being sampled.
It's all a fair bit of hassle but, for the only NEIPA I brewed double dry hopped and the above it really didn't oxidise over the few months it took to drink so it was worth it but stressful and the beer never ever got warm after the cold crash. Surprisingly I tried a bottle of it counterpressure filled from the fermenter that was hiding in the keg fridge months after the keg was finished and that hadn't oxidised either although not as vibrant as a first pour.
As a final thought on keeping oxygen out I'm not sure how much oxygen is between the hop particles making up a pellet, I hope with my having the hops in the fermenter any there is displaced by the only CO2 environment that is made by the yeast. It's probably not an issue though.
Given the smell of hops during a ferment and the dry hopping I'd love to catch that " hop gas " compress it and use it as my gas for serving the hoppy beers, but that is a bit of a challenge I reckon that I won't be taking on.
When my PID is fixed on my brew system I'll be at it again and a remake of the NEIPA is in the brew plan. Until then I'm on rations but should last out!