I just did a fun little exercise of creating a GnR "greatest hits" for the songs I like of theirs. The only album I currently have of theirs is their Greatest Hits CD. Using that as a model, I cut 7 song from it, and added two (both from Appetite). So my complete "greatest hits" from them would look like this:
-Welcome To the Jungle (great song)
-Sweet Child O Mine (yes, it's overplayed and sappy, but when you cut through that, it's still solid)
-Paradise City (arguably, best song they've ever done)
-Civil War
-You Could Be Mine (in my top 3 of theirs)
-November Rain (not a favorite, but it would be shame to not include; it's very well done)
-Live and Let Due (great cover)
-Mr. Brownstone (funky, rocking, and cool)
-Rocket Queen (sounds more like "typical '80s rock" than most of the rest of the album, but very well done)
No desire to hear anything else from their catalog. Oh, and I've never heard Chinese Democracy, which is why there are no songs from that one included.
My Van Halen "greatest hits," if I did one (which I now feel compelled to do), would be a lot longer.