There comes a point where you just think "okay, okay, ENOUGH, just stop it here, this it too much," and that point is coming soon. There are already 600+ pokes, 3 more gens or so and we'll already have 1,000 pokes. 600 is a lot already.
If I remember correctly, Digimon hit the 1000 mark a good while back. And Yu-gi-oh...there's no telling, but it hasn't stopped either of those series yet. And with other franchises like Monsuno and Bakugan making their own monsters as well, there's no reason why Game Freak should stop making new Pokemon.
When there becomes too many pokemon, a lot of them eventually grow forgettable. I already know just about every Pokemon that exists to this day, but eventually I'm going to probably forget some as more and more and more Pokemon are added to the series...
You probably wouldn't totally forget them, you just won't know everything about them. Though, with 3-4 years between Generation releases, players have plenty of time to learn all the new Pokemon and what type they, and probably a good bit of their movesets. And with the introduction of the Pokedex 3D Pro, we'll have all the info on every Pokemon right there on our 3DS in case you do happen to forget something.
You could also question Pokemon like Farfetch'd and Dunsparce that aren't exactly powerful and don't evolve. If people haven't forgotten Pokemon like these yet, I doubt they ever will. Everyone likes different Pokemon for different reasons, so none of them will be forgotten.
I just hope Game Freak stops at some point and just focuses on remakes
That would actually be a bad thing. Sales have shown that remakes of old games (at least in Pokemon) do not sell as well as totally new games. Some people won't buy a game they've already played before, even if it is upgraded. And some people don't like certain Generations or regions, so they wouldn't buy the remakes either.
or MAYBE another game like Colosseum or Gale of Darkness for the consoles which were pretty decent games themselves.
I did enjoy Colosseum and XD. Perhaps before they move on to Gen 6, we'll get a Wii U game which serves as the next 3D Pokemon battling game.
Pokemon is a big money-maker thought, so I doubt that they'll stop creating new ones as long as Pokemon remains in demand and within children and adults' interests.
Yes, Pokemon brings Game Freak a lot of money, which translates into = "Pokemon is still popular". Black 2 and White 2 are selling extremely well right now, despite not being released internationally yet. When that happens, especially in the US, their profit is going to jump yet again.