> Well written articles will generally place highly on Google's search results no matter the domain(unless you've got shady shit going on).

Absolutely. I've written two blog posts on PostgreSQL on topics that, in my opinion, weren't well covered and often misunderstood by its users. Both posts show up on the first page on a google search for "psql cli" and "postgres timezone".

I honestly never understood this whole fuss about SEO. In my opinion SEO is about good content. Good content over time will spread, which will result in a higher ranking.