Some games will retain value while most certainly not. If you have a mint condition atari or some oldies, it will sure cost lots. When I mention some games retaining value will be those
1) a great game in that current gen, great storyline, great music, great everything
2) have a continuation of story up till recently (for example MGS)
3) a collection within collections (Final Fantasy for example)
The one I've seen sold up to 600 dollars is Sealed Final Fantasy 7 Black Label. You probably wont get Uncharted 1 2 and 3 collector's worth as much unless they make 4 5 6 7 on the new gen consoles.
To actually know if it retains value, wait another 30 years or so.