Depression and fear are part of early recovery and very common. I found that the longer I was away from a drink the worse it got, and I would drink again. Then I took a different tack, got into a good program and started doing the things I needed to do in order to recover.
In those circumstance I can tell you the honeymoon lasted about two years, lots of big changes, new discoveries, getting back into life, it was fantastic. Then, after two years, it just kept getting better