Sleep are much less powerful than they are supposed to be (ignoring the further nerfs they gave sleep by not having it last for the full minute), spells like fireball aren't going to be sufficient to kill large groups of enemies.
You're also terrible because you keep conflating issues; things like sleep can be easily tuned and keep in mind it no longer has a min/max, it's simply a flat number which makes more sense for what they're seeming to aim for.
I'm not commenting on whether the changes Larian has made are good or bad. But I will disagree that "sleep can be easily tuned." The current state of the game is that goblins we fight have more HP than 5e goblins, so sleep is weaker. The simple fix I see for Sleep is to make it affect more HP. Okay, but now what happens when enemies cast this more-powerful version of sleep on you, the party, who don't have artificially-increased HP? Sleep is now overpowered against the party. To fix this, you give all PCs their max HP on levelup to account for this. But now encounters are less challenging and you have to buff all enemies' damage or HP, which makes sleep underpowered again....etc
The example above is hyperbole, sure, but still relevant. Changes made to a small thing (like goblin HP) can cascade into having to change a whole bunch of other things. If Larian can successfully change all these other things, okay great! If not, then it's a problem.