It will look a lot better than 800x600.
However, the specs of your monitor concern me a bit. Some monitors list their range like this:
15-31khz
and some list like this:
15.7;31-38khz
notice the semi-colon?
On some monitors 15 khz is supported a displayable signal, but the monitor will perform an internal line doubling. Let's hope that yours isn't one of these.
It's pretty easy to try out Soft 15khz. Just download the program, run it and click "install 15khz", make sure you are in some res like 800x600 or below and then restart your computer.
After that start up an emulator like mameUI and try to change the resolution that your games will display at. You will notice that you have many more options. Try playing a game like Street Fighter II in 392x240. Make sure you have all stretching and filters off. Also turn off any aspect ratio corretion. After than, once you're in the game you'll probably have to use your monitors horizontal and vertical size controls to resize the picture since you changed resolutions.
You'll notice a huge difference in sharpness compared to a scaled and blurry 800x600.