Your original post says this:
i'm having a hard time finding good or very good or excellent keywords. Using tubebuddy, most of the terms i keyed in, it shows that there is either a lot of competition or low search volume.
How do you guys find good keywords for videos? For a very small channel like mine, which has like 1-10 views per video, competing against bigger channels most likely wouldn't cut it.
First, I recommend the book "YouTube Formula" by Derral Eves. It changed my view of many things including the intense focus on SEO and keywords. In fact, I believe TB is attending/sponsoring Vidsummit which is owned by Derral Eves.
SEO and keywords can lead to discovery of your channel but you also have to keep the viewers long enough for them to become subscribers.
Derral's book gives a good explanation of what all Youtubers should be seeking, a loyal viewers. Loyal viewers may initially be attracted to SEO content but they may not stay long term. So, if you write a Title and description that is full of SEO keyword friendly terms that also reads and sounds unnatural, those viewers may not "stick". They take the info and run.
I am not saying to ignore the keywords. But if you want a simple answer, go after the niche keywords you can dominate before tackling the highly competitive phrases. But you can also try both and monitor your results.
It has been said by others (which I tend to believe and practice) that smaller channels should focus on niche terms, phrases, keywords. Then when you get traction, you can expand outwards. However, you can go after both when writing descriptions and in the tag section. However, the Title is where you have to really choose because of limited space. You have an abundance of space in the Tags section and Description section.