I can't remember an old game !! (^^ Found it thanks everyone ^^)

Albion, maybe?

Arcanum: Of Steamworks and Magick Obscura maybe?

Anyone remember a game that existed in the year 2000 that involved ants? Specifically red ants vs black ants and there would be 2 views. One from the side to show underground and a top view of the ground. The main goal I think was to conquer the whole house and yard in sections. I remember the ending was showing an abandoned house. I can't remember that game now.

Zarpalasjohn, do you remember the gameplay, FPS/TPS/classic strategia/Isometric rpg (like fallout 1-2).. this can help a lot :)

Rune?

The first part sounds like Nox, but I don't remember any village with cameras there :P

Sounds like the Mystery Island D-Mod for Dink Smallwood.

Could be Entomorph, although from what I remember of that it doesn't match your description that closely. Got more clues? (type of setting, approx. age of the game, that sort of thing ?)

I was sure it was a monkey island one until you mentioned the cameras... Sorry, I am of no help. :(

Beyond Good & Evil? not so 2d, but cameras..

I don't think this is it (since you mentioned 2D and dink smallwood).. but it reminds me of "The Experiment" aka. eXperience 112

https://www.youtube.com/watch?v=rNtHFHhvwSM

Plus that was in 2008 I think. Either way, I hadn't thought about that game in a long while, so thanks for bringing it into my memory! Interesting game if you haven't tried it. You control everything through the view of the security cameras

name of the magazine?

Maybe i know which game is but i don't really know the name. Is it futuristic, with an inventary with square slots like this ?

The curse of Monkey Island? (1997)

Discworld? Been a while, but I recall something similar happening there.

could this be it:
http://acidcow.com/pics/20110224/games_16.jpg

Flashback?

Maybe you should elaborate on the camera's everywhere, eg physical cameras or just camera angles etc

What OS were you running at the time?

Could you describe the main character if you remember? Maybe draw him?

Septerra Core?

Alundra?

Althought i don't think this is an RPG, could it be Escape from Monkey Island?

Detroit

sound like tech mage.

was it a game with aliens?