I love my Epson scanner/printer thing. It works better than the standalone scanners I used to have access to years ago.
Canon. Your pick.
Echoing Shego, Canon's are cheap and awesome. For anything going to print, anything scanned over 600DPI is really overkill. Most magazines are printed at 300dpi. Museum archived items are scanned at 1200DPI.
I usually scan lineart at 300 dpi, color work at 500-600 but like others say it's largely wasted if it's going anywhere but online in huge format. I think my own microtek slimscan is about ready to be replaced. I'll look into canon too, I like most canon products.
Please read my FEAR/Portal/HalfLife Fan Fiction!
Repurposed
Just make sure you buy a large flatbed scanner... something that can accept a big piece o paper if you draw big 
You can usually set what resolution you want it scanned in, but make sure yo ucheck the store's return policy 'just in case'. YOu never know. 
Thanks for the advice, folks!
If you can afford it, you want something flatbed with a true >=2400dpi optical scan. Not "enhanced" scan at >=2400dpi. It'll list the specs on the box and you want to make sure it's the optical scan that's at least that high. That'll insure that your scans will be of decent quality. Plus you want it to be a flatbed scanner, not a combo scanner/printer/fax/etc. It should do scanning and that's about it. Handheld ones are just out of the question.
http://www.virtueverse.net/wiki/Massacre_Melanie -the original Fire/Dark Corruptor -
http://boards.cityofheroes.com/showthread.php?t=115217
The Guide to BURN
So I got this one...
Canon CanoScan® LiDE 60 Color Flatbed Scanner, 1 1/2"H x 14 7/10"W x 10 1/10"D
The compact CanoScan LiDE 60 offers quality color scanning at an affordable price. The high-speed USB 2.0 connection also supplies power to the scanner no additional power cord is required. 4 easy-to-use buttons let you scan, copy, e-mail and create PDF files. It offers 48-bit-bit color, with an optical resolution of 1200 x 2400 dpi and software interpolation up to 19,200 dpi. Also features Quick Automatic Retouching and Enhancement (QARE) technology for photos to automatically reduce dust and scratches in older photos. It also auto-corrects to help with graininess, picture fading and improper backlighting. The Z-Lid expansion top allows scanning of bulky or 3-D items. Backed by the manufacturer's 1-year limited warranty.
Includes ScanGear CS, CanoScan Toolbox CS, ScanSoft OmniPage SE and ArcSoft PhotoStudio software. A USB 2.0 cable and scanner stand (for upright positioning) are also included.
Note: High-speed USB 2.0 connectivity requires Windows 2000, Windows XP or Mac OS X 10.2.7 operating systems (or later). For Windows 98, Windows Me and Mac OS X 10.2 to 10.6, the scanner will operate at (slower) USB 1.1 specifications
Think that's what I wanted? Did I do good? (It was only $50...)
Also will I get mod-punished for mentioning how much a piece of hardware cost me on the forums, or is that only for art stuff that monetary discussion becomes an issue?
Yeah the LiDE's are pretty good from what I hear.
You should be fine with that. CanoScans are decent quality and generally get the job done. You have true 1200 optical dpi with that, which is half of the nicer versions. It's always the lower of the two numbers. Generally, unless you're willing to start paying upwards of 150-200 dollars, you can't afford great quality scanners. Anything you can get that works well and is under 100 is a nice find.
If you know how to use Photoshop or other digital darkroom software, I wouldn't use the automatic correction services it comes with. If you don't, then the auto correction will make your pics come out nicer than a straight scan. It's just always preferable to do it manually if you have the ability to.
Plug it in and let it run a few scans. If you like what you have, then you got a good deal.
http://www.virtueverse.net/wiki/Massacre_Melanie -the original Fire/Dark Corruptor -
http://boards.cityofheroes.com/showthread.php?t=115217
The Guide to BURN
Um, I have paint shop pro 6.... will that work?
If I'm looking to buy a scanner, that doesn't need to scan very fast, but does need to scan very with a very high quality, what should I get, o community of artists?