Personally, I'd go with natural stone rather than the manufactured stone, but that's because I like the natural veining and coloration more than the more uniform pattern of a manufactured product. I like Silestone more than Corian, but both are too uniform for me. Seams are a problem, of course, but an expert installer can get the seams almost invisible.
In addition to granite, I'd also look hard at soapstone and especially at slate. I've seen some slate countertops at the national Kitchen & Bath show that can cover a very large area of counter without a seam. Slate is supposed to be more stain resistant. I also one did an outdoor kitchen cabinet that had Jerusalem Stone counter tops, but as beautiful as it was, my understanding from the stone installer was that it was softer than granite.
Notice that even though we did a lot of cabinets with stone countertops of one sort or another, primarily granite, we never tried to install it ourselves. That's strictly a job for the expert specialists.
All of that said, I'll be using a mix of stone and hardwood counter tops in my new house. They won't actually be counter tops in the traditional sense, because we aren't going to have any traditional cabinets. It will be a farm house kitchen with a stand alone soapstone sink on legs, with a sideboard and a cloth drape under, a stand alone stove, and furniture such as hutch, dry sink and a strategically placed dresser or two with stone tops, and a large counter-height table with hardwood top for an island, and maybe a butcher block. The fridge will be a small, 40's period unit, and the microwave will be hidden. This will not be in a separate area, but in one corner of our great room, part of the living area.
To make it work, there will be a separate utility kitchen with the dishwasher, stainless clean-up sink, food prep counter, commercial refrigerator/freezer, pantry and storage cabinets for the Tupperware, cookie sheets and such. It will be hidden behind swinging cafe doors behind the open kitchen, and will probably have inexpensive laminate counter tops because no one will see it.
All of the messy food prep and clean up will be in the utility kitchen; only my dazzling displays of cooking skills and serving will be in the open kitchen. There will also be an exterior door in the utility kitchen so it will serve the same purpose for my outdoor kitchen, which will be on the other side of it, part of the rear porch.
Attached is one of the granite-topped jobs we did, squeezed into a small area.