There are many reasons for the redness of the tip of the nose, and the medication regimen is different for different reasons. If it is caused by acute bacterial infection and inflammation, you need to consider antibiotics, the more common ones are second-generation cephalosporins, such as cefaclor and cefuroxime, etc. If it is caused by an allergic reaction, consider antihistamines, such as loratadine or desloratadine.
If rosacea is the cause, vitamins, hydroxychloroquine, doxycycline etc. may be used.