One last thing to keep in mind...it is not fair to compare N64 to PS2, Xbox, or Dreamcast. Those are Next-Generation systems, comprable to Gamecube, not N64. They are not in the same generation, so of course it is not a good comparision. (Like comparing Gameboy Color to Gameboy Advance. It is just not fair.) I hope this helps you to make the right choice.
The N64 is a lot more graphically capable than the Playstation. The downfall for the Nintendo 64 however, which eventually let Playstation surpass it, was Nintendo's decision to go with the cartridge format, which scared game developers away due to the cart's limited memory capacity.
Overall, the N64 is home to some of the greatest video games ever made, and is worth your money.