David,
Much of what you ask depends on your preferences. If you like tinkering with a computer, most things can be done by a home user. But then again, some of the new, fast computers can be purchase for under $500, depending on your needs and wants. You can also choose to have one built at a local shop with all the "doo dads" you want on it. It's up to you.
How large are the graphics files you're using? A quick check for the Dimension L Series computers at Crucial.com shows that it takes PC100/133 memory sticks, has two memory slots, and appears to have a max of 512 MB. Memory is fairly easy to install and can be done by the user if they are even slightly mechanically inclined. Replacing the current 64 MB with two 256 MB modules would certainly kick up the ability to work with graphics files. But unfortunately, no matter which operating system you have, (you'll need to search the Dell site to see if your model supports other operating systems), you'll still only have the option to use the 512 MB on that motherboard. Larger and more complicated graphics will require a faster computer with more memory.
In addition, if you're thinking about installing a different operating system on that machine, you'll need to verify that all your current programs and hardware are compliant with the new OS and that there are updated drivers available for all hardware such as video and audio cards, plus modems, etc.
Hope this helps.
Grif
I have a Dell Dimension L566 CX machine with 64 mb RAM,running Win 98 2nd ed. As I ask it to do more and more [particularly graphics, I don't care for games] would upgrading my RAM solve this - and could I install it myself? And could then run a later Windows version? Or would I be better advised to take the more expensive option and just buy a new machine?
Thanks
David

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic