I look at my collection daily... but inventory and such, maybe once a year... if that. And every time I do that, I find games that I forgot to add to VGC. Duplicates however, I'd say never, but every once in a while I'll go and update my sell/trade list.
I will say though, I do Ring Fit daily in my retro game room, and when I'm doing exercises that have me looking away from the TV, I'm looking at my collection. Mainly Genesis, OG Xbox, Xbox 360, and N64. Other than N64, I'll see games for Genesis I'm not patently aware that I owned, or I'll see random games and think to myself "Oh, I should play that what I'm done exercising."