Finding a niche is difficult at first but with practice, it becomes easy to find a good niche.
Now to answer your questions:
As you said, you found niches from Amazon, which can be good and bad at the same time. If you have niches from Amazon, try to find competitor websites. Check keywords, what ranking what not.
Most of the time, only e-commerce sites rank on keywords and you need to stay away if e-commerce sites are ranking.
If you found your niche from, let’s say, motion invest, yes it’s true, there are not many sites available, but they are sure shot sites. You need to wait for a good site that will work for you, easy for you.
It doesn’t matter where you find the niche from, all are good.
Let’s take an example.
You find a niche on Amazon, let’s say, a “hair dryer”.
Now do further research. Find keywords related to this seed keyword which is “hair dryer”
find competitors
check what kind of sites are ranking. is it blog sites? is it e-commerce sites? Are there any other big sites?
if there are blog sites, which means this can be a good niche, but then do further research and find sites with low da dr, fewer articles, less RD, some traffic, etc. If you are able to find such sites, then these are your competitors, and after thorough research, you can work on the niche.
If not, then leave the keyword and find another keyword.
Now, this way, you’ll learn, keyword selection, niche selection, you’ll also encounter new niches, etc.
Apart from this, check sites on motion invest, check their keywords, and do your research, even the big sites can give you small niches.
How do I learn to find niches??
Just by watching the videos of Blogger Vikash channel. Most of the time I do random keyword searches, no motion invest, no Amazon.
Try to watch the keyword research videos as many times as you can.