I really like the Anno games (well, at least Anno 1404 and Anno 1800, the only two I've played)
They go real fast from "develop a boring village and wait for it to populate" to "holy shit I'm juggling real-time with 15 settlements on four different maps with crazy complex production chains and like 12 trade routes while dealing with pirate attacks and doing quests for NPCs and going on RPG-like small adventure scenarios with dice rolls"
Also all the NPCs in these games are strangely wholesome. They're nice and charismatic, even the pirates
1800 is really good. The game only gets really satisfying for me when you start to open up new maps and make your first cross-continent trade routes, mind you.
I suggest trying again, yeah; initially it is indeed pretty frustrating - never enough workforce and you suddenly need 150 of them for the next tier, etc. - but there is a balance, and once you get it it's extremely satisfying. Restarting any time you feel like you messed up initially is also probably a good idea.
Also I don't think I've ever played this game with agressive or even competent AI; they exist and are quite good IIRC, but I always select a single AI opponent, the one that never ever attacks you and is always nice and wholesome and even gives you gifts when you struggle (in 1800 it's Bente Jorgensen, she's incredibly nice and even ask for permission to settle new islands). The pirates are enough of a headache honestly, and once the game gets going you've got so many fucking things at the same time on your plate an actual competing AI opponent on top of it (never mind three, which is the default) would be too much IMO.