There are many other alcohols, 2M2B(
https://en.wikipedia.org/wiki/Tert-Amyl_alcohol) for example, which are "alcohol without the hangover" in a sense. I seem to remember a scientist looking into ways to deliver these alcohols(absorbed in cellulose IIRC). You'll note that these chemicals, like alcohol, can also lead to overdoses and since they are much more potent it is even more difficult to ensure one does not overconsume. I suspect that is why they have never been sold commercially for recreational consumption.
Of course, you will likely always get some after effects from any mind altering substance as you brain returns to normal, but alcohols which do not metabolize to acetaldehyde are going to result in much less suffering the following day or two.
I was somewhat fascinated by other alcohols for quite a while. A microbrewery I used to frequent had some abnormally potent brews despite being around 6%. By potent, I mean that my friends who would normally split a 36 pack of Coors lite between the two of them would be heavily buzzed after a pint or two. A little research led me to discover that fermented beverages are a complex cocktail of chemicals, many of which are psychoactive. Some of those chemicals can actually interfere with a simple alcohol measurement based on specific gravity, so you could be under-stating the ethanol content while also producing a brew with higher levels of mind-altering substances.
Here is one such substance: https://en.wikipedia.org/wiki/Tryptophol When yeast are nutritionally stressed, they will often excrete amino acids and other chemicals with alcoholic functional groups attached. By tailoring the nutritional profile of the wort, you can select for higher or lower levels of these mind altering substances. I suspect it has something to do with how some beverages, notably cider(very poor nutrition for yeast) can give me a hangover before I even manage to fall asleep.
In any case, it's fascinating that you can setup a brewery and crank out mind altering chemicals and be largely unregulated beyond the amounts of ethanol(and maybe methanol) in your products.