We use Tiled for map designing on our game. Honestly it's an amazing tool I highly recommend! The more I learn about it, the more I like it.

You mentioned Terrains, which is a very cool tool in it. I also highly recommend learning Automapping. It's a bit of a learning curve, but the flexibility you get from that feature is unmatched.