I think using alcohol as an impromptu way to sleep makes sense but it should have long term downsides if you do it too much.
Drinking before going to sleep is a common way to develop insomnia, so in game after around 3-4 nights in a row of sleeping right after drinking it should make it harder to sleep in general or something