We decided to spend Hogmanay in Edinburgh in 2005 and moved to the Caledonian Hilton from the Sheraton Grand and Spa on the 1st January. We stayed until the 3rd. In comparison to the Sheraton, the Hilton hotel is far more modern. We were on the first floor and the colours were a wonderful baby blue. The room was very stylish, decorated to a high standard in muted browns and cream. The bathroom was small, but clean and in a modern design too.
We ate both nights at the restaurant (as we were too lazy to go out). The food was excellent and the set menu good value (3 courses for under £20). Although our waitress on both nights was exceedingly rude, she was still professional (strange contrast, I know), and we tried not to let her sour face spoil our evening.
The only complaint I would have other than the waitress service was the health club. The standard fell far below par. The club did not have top-range equipment, the sauna was tiny and the pool was inundated with small children.
However, location-wise it was perfect and as we only paid £104 per night (B&B directly via the hotel), it is hard to find many faults with the Caledonian Hilton.
On the last day we decided to visit the Glasshouse and were blown away. What a beautiful hotel! If you want modern, uber-stylish and something a little exquisite, I would definitely recommend the Glasshouse first. The only downside is that there is no Spa at the Glasshouse. (On a side note - if you want a great Spa, you cannot beat the Sheraton Grand and Spa. Though you might have to pay £20 for use if you stay in a standard room).