Some of the Moonlight Falls rabbit holes are wonky. I had the same thing happen with that ghost hunting opportunity in my dynasty (gen 2's spouse is a ghost hunter) but I just canceled the opportunity to get rid of the music and it stopped.
Gen 2's spare also couldn't use the science lab to make her imaginary friend real, even though she had the components, when she went to click it, the option just never came up. Also, gen 3 couldn't go to his badging ceremony for scouting at the school. He had the opportunity, but there was never an option to attend when the building was clicked on, and it expired.
I've been able to get enough opportunities to meet the black ops so far (gen 3 is still a teen and hasn't had any, but they come regularly enough as adults that I haven't had a problem yet) but it is an issue in Moonlight Falls for sure.
That said, I've been able to complete some in the spa/bookstore and the bistro, and I think the theater/criminal building without issues. My ghost hunter was also able to get his trophies and badges from the combined city hall. So it's not all of the rabbit hole opportunities, just some of them.