The last time that happened for a console for me was the Dreamcast. It was the first of that next-generation of console that was such a massive leap forward in 3d graphics from all the limitations of the PS1/N64. It was built-off Windows CE, the memory cards doubled as mini-Game-Boys, had an ethernet jack for playing Phantasy Star Online, a slew of fantastic arcade ports, weird games like Space Channel 5 + Seaman, stylish games like Jet Set Radio, graphical benchmarks like Shenmue, etc.
I know the PS2 was massive, but I wasn't that impressed at the start because some games just struggled to use the emotion engine well, but after the 1st year it was an easy buy for me. Last time I felt any hype was the Xbox 360 because of Gears of War 1 + Xbox Live feeling the a cool step forward for online gaming on consoles.