Welcome TempusNusiku

I think most of the digital mappers here use Photoshop (or the free equivalent Gimp). Lately I think ProCreate has been gaining popularity.

It also depends a lot on the type of map you're working on. The best way to learn, really, is to get started and share a WIP in the relevant forum.

Wingshaw