It's hard to say for me, personally.
I don't think I can fairly assess the hype for the PS2. I was 19, and the anticipation and excitement for launch is something that I personally don't think has been matched since. But I was young. Coming from the PS1, and seeing what was possible on the PS2 by comparison was mind-blowing at the time. News channels were running stories about the PS2, and how much of a monster it was in the eyes of the public. Lines out the door, around the block like it was a movie release. It was pretty crazy.
The PS4 also had some pretty great hype behind it, particularly coming from the PS3 which, had a rocky start and a very high price that dampened the anticipation somewhat (though it was still pretty damn high, at least among my friend circle at the time). The PS4 had a great price, despite the launch software looking so-so.
The PS5 is in an interesting place, because it has some incredible hardware, at a pretty fantastic price, but what sets it apart from previous PlayStation consoles is that it's launch lineup is pretty fucking incredible, as is it's first year lineup of titles. Not since the PS2 has a PlayStation console had this strong of a year one lineup of software.
If I had to rate anticipation of PlayStation consoles based off of my own experiences, I'd say
1) PS2
2) PS5
3) PS4
4) PS3
1) PS5
I rank the PS1 so low, because, at the time, myself and most of my friends were marginally skeptical about this newcomer Sony trying to step into the ring with Nintendo and Sega. Then Final Fantasy VII was revealed, and we definitely changed our tune, but that was still years off. While the excitement for a 3D console was high, the launch and year 1 titles weren't exactly much to write home about. For me, it really wasn't until Tomb Raider, Resident Evil, Final Fantasy VII, Metal Gear Solid, Castlevania: Symphony of the Night, and Silent Hill that I really fell in love with the PlayStation 1.
PlayStation 2 was on a whole 'nother level by comparison. I still think it's possibly not surpassed in terms of anticipation and global excitement, but the PS5 certainly feels really, really close on its heels. It may very well be number 1, but I can't help but feel like my assessment is clouded by my memories and nostalgia of the PS2 launch.