There is the Anno series of games, which are technically RTS games but if I’m honest I find them the most fun when I go out of my way to avoid combat/micromanagement. I’ve only played 1404, 2070, and 2205, 2070 being the best in my opinion, but it has a bad history with DRM so I’d suggest 1404 (known as “Dawn of Discovery” in the US because us americans are afraid of numbers apparently).
Edit: looking at the steam page it looks like they decided to take 1404 down and made a new page where the game is (mostly) unchanged besides requiring you to jump through all the BS hoops that 2070 did, so I’d say if you’re gonna spend money get 1404 on GOG, or if you are willing to do unspeakable things go with 2070.
I don’t think this can really be answered until after the fact. Anything that I (and I suspect most) people could say about an artstyle are going to be particular to an instance of that artsyle. If I’d give advice as someone who is neither an artist nor a game designer, what attracts me more than anything is a unique artstyle, which, if I’m gonna give a brutal opinion, starting from a vague category like ‘pixel’, ‘hand drawn’ or ‘3D’ probably won’t get you there.
I feel like I even struggle to answer your question at face value because it doesn’t align well at all with how I conceptualize game art. For example, Cruelty Squad is a game that I don’t think I’d have gotten if not for it’s artsyle. Like, sure, it’s 3D, but it’s a lot more like a PilotRedSun animation than it is a game like TF2. Or take a game like Factorio: most of the assets of that game are pre-rendered 3D sprites, so despite being artisticly unique in a way that interests me it doesn’t fit into the categories you’ve asked about. The best I can say is “I dunno”, and I don’t think anyone else can answer it further than that.