SEO takes time to build up organic traffic, so be wise to choose the content idea because you don't want to invest your time/money on that which will not pay off in the next 6-7 months
Here are the top 7 SEO content Ideas that give 10X conversions:
Idea 1: Comparison Blogs
Content- "Content Competitor vs. our tool"
Example: Sparkloop.app

Idea 2- Curate the tools
Discover a set of tools within some category
Example: Zapier.com

Idea 3- Alternative to blogs
Alternative to X
Example Zepel.io

Idea 4- How-to blogs
Teach people how to solve a problem they are facing
Example Veed.io

Idea 5- Product Use-case
Show up when someone searched for a problem/solution that your tool solve
Example- Rightmessage.com

Idea 6- Stories about why and how the product is built
This is the great example of building in public
Example- "Potion.so" I like how he's documenting his whole journey on youtube, you can do this by writing blogs as well

Idea 7- Customer Case Study
How someone solved the common pain point using the tool
Example: Zapier.com

If you got value from this post then please upvote and also I have posted a Twitter thread about the same, Please retweet that thread so that more people can get value out of it.