Ok, my choice of words may have been poor, though you really took that too personally. I didn't call your game ridiculous, I just think that having 300-500 types of resources is going to be overwhelming. I would honestly think that anything above 50 or so would be out of hand for the majority of players, but again, and I don't want to repeat this every post, this is just my opinion.
Going by what hpdvs2 said - Civ V's diverse selection of resources were used for a lot of stuff. The resource view where I could see what resource was where was helpful, but unlike Civ 4 where you only had to have at least 1 resource of that type to produce units that needed it, Civ V required you to keep count of exactly how much you had. Leikaru, you didn't specify how your resources would work - the thing is with so much production going on, unit movements and city management, I just never could micromanage my resources in that game. Most of them were acquired automatically by automated workers, and I was often surprised of what I had.
I honestly don't know how to improve it. Going with my experience of Settlers VI, while there were a lot of resources, you worked up to using them gradually - at first only caring about wood, stone and food. Then gradually as you advanced in title (the title of your knight, but it's just an advancement of your entire city) the needs of your citizens and the types of resources you had to gather increased. I guess the difference there is that I wasn't thrown into a world where there's a ton of stuff to manage at once, but instead was gradually introduced to new things I could do.
Again, since you say you're working on your idea, I don't know what your idea is. Based solely on you saying that you'll have 300 - 500 resources, I don't think there's a good way to make the learning curve easy enough. At best you'll be spending a lot of time introducing these resources and their function, and at worse, you'll just throw them at once at the user.
This is also based on the fact that Civ V is probably the game with most resource management, and like I said, I never did get the hang of that completely.