Sounds like that's where we're heading (NCQ & dual core).
Doubtful, people still want big and cheap and drives with TCQ aren't cheap.
it's not a major one [to me] since as mentioned, if you have programs like PartitionMagic, resizing (not repartitioning) partitions shouldn't be much of a chore
I take it you've never had Partition Tragic fail on you yet?
and to a further extent (depending on degree of frag.) program crashing occurs
Fragmentation can not cause crashing. Unless you're stick in 10 years ago running Win95 or something, then anything can cause crashing.
For one thing I could waste time defragging my entire hard drive every so often or I can create multiple partitions to decrease the adverse affects of fragmentation that would otherwise in a single partition environment span across the entire hard drive/disk(s) & so with multiple partitions, fragmentation is isolated within a single partition while other partitions within the same physical hard drive are unaffected.
Or you could set it to run at night and not worry about it.
And excessive fragmentation is mainly a Windows problem, I run Linux with XFS and I never defragment my filesystems because there's no need. Sure there's fragmentation, but with things like read-ahead and the general layout of XFS there's pretty much no slow down over time. This Linux installation here is over 5 years old and I've defragmented it maybe 5 times at most, just f'ing around to see how long it would take and if there was any speed difference and there was nothing noticable.
The last two are pretty bad because of bittorrent, but even that fragmented I can't say I notice any slowdown.
actual 460608, ideal 459661, fragmentation factor 0.21% -- root filesytem on my workstation
actual 29517, ideal 22034, fragmentation factor 25.35% -- /home filesystem on my workstation
actual 149028, ideal 33728, fragmentation factor 77.37% -- a data drive
actual 62748, ideal 21966, fragmentation factor 64.99% -- another data drive
I've never had problems or "overhead" with multiple partitions that I can remember
Sure you have, you just probably didn't notice. I'm sure you didn't do time trials comparing a single partition to multiple. When you run a program from D the drive has to keep jumping back and forth between C and D because most Windows support libraries are on the system drive and the program and it's data are likely all on D. How much time it adds to the startup depends on the drive seek time, how far apart the partitions are, how far apart the data is, etc.
with multiple partitions you wouldn't have to backup then restore your vast storage sucking collection of multimedia files onto spans of DVD discs or to the unfortunate soul, CD's... (Yea you could copy said files from 1 hard drive to another during a reformat of main partition but as mentioned, that's not an option)
And what happens when you accidentally format the wrong partition? It happens to everyone that formats regularly eventually and it's a lot harder to do if you have more than one physical drive.
You're saying that by having 3 partitions, 1 to which is accessed rarely (backup OS install.) while another which only has to access 1 file at a time (MP3, WMV, etc.). Will cause much overhead, so much that it's not worth doing?
Of course not, that's like saying that adding a second sound card will slow games down because the OS has twice as many sound devices to look at.
But it's still largely pointless. The OS backup should be on a seperate media (tape, CD, DVD, etc) and your important data should be on another physical drive and probably also on a backup media like tape, CD, DVD, etc. If the OS backup you're talking about is a second installation for rescue purposes make a WinPE CD with Bart PE and kill that worthless partition.