My understanding is it’s a combination of both - red dwarfs are the most numerous and super earths are the most easiest to detect with them (smaller star, larger the effect of the planet on its characteristics and luminosity).
I am also convinced we will find planets better suited for us than earth eventually. But I doubt any of them would be in any meaningful close distance.
Even if you can imagine a 100 year or 500 year ship (like in Expanse) that can get to a planet 10 LYs away, imagine if it’s 100 or more. We might be SOL.