So I am looking to play around with the idea of building a top down (maybe with isometric styled graphics) 2D survival / crafting / adventure style game (think Terreria / Starbound but top down or Forsaken Isle which would be a much closer example). Basically a game where I am going to want to generate and save random maps, make a lot of the world destructible (trees, rocks, etc.), allow the player to modify the map, fight monsters and such, and probably a bunch of other smaller mechanics (food / water, health, maybe NPCs, etc.). I am looking to see what would be a good choice for a game engine for this style of game. I am not looking to create my own engine with lower level libraries / framework as that it not a part that is extremely interesting to me not to mention that it would probably take me a while to get something that is anywhere close to ok anyways. I don't mind an engine that requires coding (I actually prefer coding over visual style programming) but I am look for an engine where the coding is not C++ (not a fan of dealing with manual memory management and stuff like that).
Right now I am leaning toward Unity as they have an interface to the engine that I quite like, I don't mind the C# language (even if they are on a older version of mono), and it is something I have some experience with (though it has been a good 2-3+ year since I really did anything with it up until just playing around with it last week). The biggest performance issue I think I would probably face would be just rendering the world. I would like to be able to load maps with hundreds of thousands of tiles but with the world being highly destructible, I imagine I would need lots of colliders to be able to handle that would and that would be performance intensive (I imagine the best way to handle that would be steaming the world in and out as the player moves but of course that is something I have no idea about and would have to figure out or figure out a different way to handle it). I just want to make sure the engine itself can handle something like this so that I can mostly focus on building out the game itself.
Not sure if there is any other engines that I might want to play around with before I dive deeper with Unity.