ASP.NET Core - Why async await is useful

Did you ever wonder why you "should" use async and await in your ASP.NET Core applications? Most probable you heard something about performance. And there is some truth to it, but not in the way you might think. So let's discuss this with smaller examples.