This guy may be wonderful, but he probably isn’t the guy for you. If you interested him, he would not have ignored you. Texting him drunk probably pushed him even further away. What you need to do is give this up.
I suspect that obsessing about this guy serves a purpose. Maybe you are nervous about meeting men and this fantasy helps you avoid the task. Or maybe your self-esteem is suffering and you don’t think you have what it takes to attract someone who is equally attracted to you. Or it might be something else.
Please try to figure out what problem thinking about this man helps you solve. If you can’t do it on your own, please make an appointment with a therapist to help you get over the relationship-that-isn’t so you can make a real one.
You deserve to be loved by someone who will love you generously and sweetly and without games. Don’t settle for anything less.
I wish you well.