Neil,
I am a web designer. You can look at my work here
http://www.madeofclay.com if it adds value to my advice. Thats my personal site, and I also work a day job doing web design for "the man".
I'll address zekthedeadcow's points first:
Don't worry about 480X640. It is hard to make anything at all look good at that res, most software doesn't even look right on that res. People who actually use that res level are used to things looking like crap, so they won't notice the difference. But you might want to seriously consider adapting down to 800X600.
Frames can be used for good sometimes. You just have to do it in a way that will eliminate the possibility of the horizontal scrollbar. (The side-to-side one at the bottom of the page.)
Ignore the comment on left-justified websites being amateur. zek's website might look a little better than yours, but just because its centered doesn't make it look pro. You can use a variety of layouts and make it look nice. The "pro" feel comes from a combination of clean graphics, good navigation, readable content, and attractive text layout.
First thing I would do on your site is change the font. Times Roman is the default font, and using it on a website always looks bad, in my opinion. You need to use a font that people have installed on their computer, or else you get Times Roman again. So for Windows users you can get by with Arial, Verdana, Tahoma. For mac users you want to throw in Helvetica. Arial covers Linux people too. I would look into CSS (Cascading Style Sheets) to control your fonts. With that, you can control what the text looks like on the entire site with one file, and just put the link to the file at the top of each page. You can get some ggod CSS info here
http://www.w3schools.com Make the text a little smaller too.
I would lose the animated scratching guy. It just looks a little cheesy.
Here's a great site for just seeing what's out there, and what people generally accept as good design. I don't agree with all their choices. Some of them are too hard to navigate. But in general it shows a little of what good web design is.
http://www.coolhomepages.com
On content: Here's what you want to keep in mind. People come to a website and want to understand what "the point" is right away, or else they leave. Kind of like how record producers treat music. You have to win them over in the first few seconds or its over. If you write your content with that in mind, you'll be fine. The home page is the most important.
Hope that stuff helps.
Clay
