You could try CBT or Hypnosis. Pick one, try it, and if you have success then great, otherwise try the other.
You seem a little skeptical about hypnosis because the stage show you went to didn't result in you being hypnotised. Well you have to want to experience it for it to work. If you were not in the right frame of mind it makes things difficult for the hypnotist. Be aware the hypnotist has no mental superpower to take you over. Only one person can hypnotise you, and that is yourself. All the hypnotist can do is set the environment and give you helpful suggestions that you can chose to respond to or not. Even if consciously you think you want to be hypnotised you may have doubts you aren't consciously aware of about 'letting go' like that. But a therapeutic session is going to be less stressful than a stage appearance, where the suggestion is that you may be encouraged to act the fool for the entertainment of others.
You ask if it works, like many other treatments it can do, but doesn't have a 100% success rate. Ultimately it can only bolster what you already want to do. Along the line of giving you more willpower maybe. But if you decide not to change, maybe because you don't see why you should deprive yourself of a night on the booze, then you won't. It isn't a panacea for all ills, merely a helping hand.