The Gold Experience is really good. Such a long career is hard to judge; but none of his last two decades of output is anywhere as good as his 80's run and still comes in behind most of the 90s, IMO. To call them great, YMMV and IMO (of course), is maybe a bit of stanning. Prince is my favorite artist but I still like to be honest with myself about when something is the shit and when it's just shit.
My subjective rankings divided into Top Tier, High Tier, Mid Tier, Low Tier (not incl any posthumous or side projects/proteges and leaving a few off); breakdowns not in any particular order
Top: SOTT, Purple Rain, Dirty Mind, 1999
High: Controversy, Around the World in a Day, Parade, Black Album, Love Symbol, Lovesexy, The Gold Experience
Mid: The Rainbow Children, Graffiti Bridge, Self-Titled, Diamonds & Pearls, Batman, Chaos & Disorder, Emancipation, Crystal Ball
Low: For You, NEWS (I really enjoy it, but I have to be honest about what it is), Come, Rave, Musicology, 3121, Planet Earth.....and everything else after that