Enjoying A Coin Collection

Well, IMO it depends how you collect. Do you collect, or do you accumulate? That is, do you just buy what you like with no rhyme or reason, or do you have a focus of some kind? If the former, you will definitely have a hard time, since while you had a beginning (no coins), you have no destination, and even the journey is foggy. But, if you have a specific focus (or foci), then the enjoyment comes from filling in the blanks, or finding variants of existing coins, or learning about the history of the issue, or by showing them off (creating a website for display is easy, though good photos are much harder ).
Here's what I mean:
Person A likes coins. Doesn't really care what coin. Age, material, country of origin, doesn't matter. If it looks interesting, he picks it up. Ask him what he collects, he'll say "coins." Ask him about them, maybe he'll shrug and tell you that they're pretty. Maybe he'll know what power issued them (depending on age and language). Ask him, What's next? and he'll shrug. Billions of coins out there, after all, something nice will come along. He accumulates, and without any criteria for purchases, doesn't have any criteria for enjoyment.
Person B likes coins. Specifically, 19th century German States (that's from where an ancestor came) and US Barber coinage (she just likes the designs). Has a few Krause lying around to help reference what she has and what she should be on the lookout for. Scans certain websites for info on recent sales, buys old auction catalogs for reference. Has a few of them slabbed, may or may not TPG some others. Reads some history about contemporary Germany and USA to get context about the imagery on her coins. Looks on her shelf, or at her spreadsheet, to take pride in what's she's picked up so far, and to target what might be next on her hit list, and might even write and publish an article or three about the coins to share the knowledge.

Good pics aren't impossible, only challenging. Good all around lighting (white, not yellow), maybe a few spotlights with diffusers, a camera mounted on something solid, etc. My guess is a few minutes spent on searching, "photographing reflective things" will turn up some good tips.
If you're closer to the second type of collector than the first, the joy likely comes from the satisfaction in what you've accomplished and the anticipation of what's next, and in what you've no doubt learned along the way. Another thing to consider, is changing up how you hold or display them. Got anything rare or expensive, might be worth slabbing. Or, uniformly encapsulating them all. Or moving away from binders and towards trays, which would let you see many at the same time. It's also possible, depending on your specifics, that you're just bored (hopefully temporarily) of what you've been collecting. If it's late USA silver proofs, maybe try small-denomination Chinese gold, or whatever. Just ideas to chew on.

Proofs are easy to take pictures :)

That's what I'm doing right now in another tab.

This has been one of my outlets for sharing my accumulated knowledge. I can highly recommend it!

For me, its the thrill of the hunt

I enjoy my coin collection in a similar way that you enjoy your vinyl records. I have a "desk coin" that sits on my desk for weeks or months, that I listen to over and over. Sometimes it's the most recent purchase, other times one I've had for a long time that I pull out because a similar coin was posted on a forum.

For example, I bought a 1946 Canadian dollar years ago. Originally I was filling a gap in my Canadian dollar collection, MS60 at a decent price back then. Then I later pulled it out and realized it was the short water lines variety. Then realized it had a die clash on both sides, and the obverse clash was not documented anywhere that I could find. Then I had it re-slabbed at another TPG and it got MS62, and conserved, which was an opportunity to examine it again. Then someone posted their 1946 dollar in the Canadian forum, and I looked at mine all over again. This time I noted that it had a distinctive die scratch or crack in the lower reverse, so I went looking for a match to that die in Heritage archives. I found several coins with the same marker, from before the die was clashed. I found only one other out of about 150 coins that had the same die clash on both sides, so it was relatively scarce. I also noted that there were actually at least two versions of the short water lines variety - mine with only SWL on the right of the canoe, and one with short lines on both sides of the canoe. All of the right-side-only SWL also had my die marker, with and without the clash. I also noted that there were three versions of the reverse die clash, with different offsets of the clash with George VI's nose, and two of those were clashed on the obverse in different positions at George's eye and inside his ear.

I also found that there are at least 3 date positions - high, level, and low 6. And I found additional die polish marks around the date on both circulation and specimen coins, indicating that a specimen die had been reused for production coins.

All of this was the result of that one "desk coin." So that's how I enjoy my meager collection. Every coin can end up being an adventure.

I started off years ago just collecting whatever I could - usually British cos that's where I'm from. Then the gaps started getting expensive to fill so I started to specialise. At this point I discovered that research is key to giving the collection depth and meaning. Must admit, that side of it is very rewarding, cos there's always something new to discover, and eventually share. I think that that's when collecting becomes numismatics. But as ever, fun...