Yep, you are missing something.
I use mine to control my lights. I can't remember the last time I used a wall switch. Instead, I give voice commands like "turn on the downstairs lighting" and three rooms come on at the correct brightness and color.
In the kitchen, I use them constantly to convert measurements and set timers. When the timer goes off, the lights flash downstairs so if I'm not in the kitchen anymore by then, I won't miss it. I also use it to play music.
In my bedroom, I use them to listen to audiobooks, and sometimes to play sleep sounds like rain. I can find out the time without rolling over or even opening my eyes just by asking. And, if it is too cold or hot, I can change the thermostat. I get the weather forecast while I'm getting dressed, so I can pick the right clothes for the weather.
The main thing you are missing is the other devices that integrate with these assistants. If you had them, you would know what all the fuss is about.