Be it just a single night or an extended stay, downtown Raleigh hotels are the best way to experience the city in style and comfort.