This is something that happens commonly enough that drug manufacturers, well, companies which make prescription medications at least, started research on hydromorphone, oxymorphone, and morphine nasal sprays or fluid for instilling into the nose, and I believe Stadol Nasal Spray may have been the first formulation for human butorphanol dosing as well . . . I remember when people were able to get a powder for insufflation for use as an appetite suppressant and metabolic stimulant -- caffeine + benzocaine + phenylpropanolamine was the formula I believe. That or another formulation of OTC diet medication was also the last injectable medication available over the counter in the United States; April 1976 I think was when the general prescription laws were changed to mandate that . . . I am pretty sure that the insufflation powder in question could be used in analogues of crack and White Tornado . . .
Something I learned the hard way was that even with sublingual administration being close to the way nasal administration is absorbed by the body, there may be other ingredients which are not pleasant to have in one's nostrils, such as alcohol or at least lots of alcohol -- I learned this using an eyedropper to put Tusscodin Sublingual Drops (nicocodeine HCl) into my nose one night about 20 years ago. It was a cough medication, but a cough medication that makes one feel just like Jesus' ear, nose & throat doctor at the right dose . . . snorting smashed-up Vilan (nicomorphine HCl) tablets and the injection fluid sprayed or instilled into the nose are very nice though -- nicomorphine, being a 3,6-diester of morphine, works the same way as smack, which is commonly insufflated . . .