ArchiCAD is the better solution from my experience. I am biased though as I have spent the most time in ArchiCAD. But that is because the learning came so easily. It is great for all the the scales of projects you have described. My work is mainly on a residential scale and as you can see from Graphisoft's website it can handle massive buildings too.
I have tried to dive into Revit several times but I feel like the user interface is clunky and more for someone with a software engineer's mind. You mentioned the "spreadsheet" feel. I am a graphical person and want graphic feedback as I am creating, which ArchiCAD excels at providing for all of its objects.
IMO Revit's strength is model integrity (ie. ability to create complex parametric relationships with constraints), full bi-directional associativity (change a temporary dimension and the object will adjust with it) and some enhanced tools to create freeform shapes easily inside the software. This is great if you are creating conceptual designs with bizarre geometry but that is not what most people are doing.
ArchiCAD's project navigator is essential for me to keep everything organized and move from the modelling phase to layouts. Revit seems to fall short in project organization (a single tree of folders to sort through all the views, layouts and families is too cumbersome)and its 2D drafting tools are not as intuitive or flexible. In the end my product still ends up on paper and it should look elegant and it should be intuitive to make it so. This is where ArchiCAD surpasses Revit at the moment.
Coming from an AutoCAD background I feel that the 2D drafting tools in ArchiCAD are a much friendlier transition and in some ways the line tools are superior such as being able to trim with a simple "Ctrl-Click". The offset tool takes a bit of a trick to get used to though. Lineweights are easily controlled in pts or mm and color schemes can be modified or created as needed.
And sometimes Revit's strengths can be a huge problem. We had one colleague using Revit run into a problem when the ground floor of a building needed to be lowered at the clients request. The building was already into final submittal and this request was holding up the building permit. The Revit model was so constrained that they needed to virtually rebuild the entire ground level whereas in ArchiCAD all it would have taken was lowering the 1st floor slab a couple feet.
ArchiCAD has flexible parametric objects, meaning that you can customize a door panel or change a door handle very simply. In Revit you need to create a new "family" if you are to change the individual attributes of an element.
I have also tried Vectorworks 2010 but the user interface seemed convoluted. I think I would need to give it more of a chance but my intro to ArchiCAD was much simpler and more intuitive out of the gates.
Look into the product documentation for each software title as well. I have found Graphisoft's manuals, tutorials and other support resources to be excellent and reference them often as needed.
In sum, it is good that you are evaluating the range of BIM products. In the end you need to find what you enjoy the best. A tool that is no fun to work with is not worth it, especially in a creative pursuit.