Don’t be quick to dismiss “dead” or esoteric languages. They usually come with frameworks that solved virtually every problem imaginable over the years. Building a thing may involve programming but any veteran programmer would tell you that if they could solve a problem without writing a single line of code, they would gladly do so. However, if your goal was to find a programming language to fall in love with then my answer wouldn’t apply and I would suggest that you try all of them!
