Of course you game will look best in the "native res" it was made for. I would suggest making most games in 800x600 and scaling down to 640x480 or up to 1024x768 or more if need be. Lots of games don't have scaling, but it is a nice option as long as the graphics are scaled with a decent algorithm so they aren't horrid looking.