Does your clip have enough handles to add a transition in that spot? Are you trying to add a wipe to the end of the timeline? Some effects require two clips next to each other and won't work with just one.
What about if one shows it is available but I drag it onto the clip and I get a universal NO symbol that hovers over it? I cannot add even simple things like a wipe etc.
If you move your playhead over the footage, do they become active? Which version of Premiere are you using? Did this suddenly start with an update? Sorry for the frustration, and thanks for reaching out.