All content is dps oriented, basically all missions progress is faster and much more enjoyable with the builds that can produce the most damage. Sci and tanks fail at that so hard it's not even funny. Support roles are no longer required nor necessary. Currently, unless you are very bad at making adequate builds, you can heal/support yourself with just lieutenant eng/sci and usually you can survive long enough to finish off most opponents. No need for support from tanks or sci.
Do not get me wrong, this is not a cruiser vs escort build threads (we already have enough of those lol). This is about the fundamental roles of tanks/sci builds and their eventual future extinction. A cruiser can be build to tank, but in consideration of current content, it is so much more rewarding to scrap the tankiness for you and your team to boost your personal dps and power levels with abilities like aux to batteries (technician doff) or directed energy modulation, why not? Extend shields is a very useless ability, arguably still of some importance in PvP (debatable). Sci used to pride themselves at being the best healers/strongest shields with incredible ability to disable a ship's subsystem. Except that now, you have hybrids weapons (polarized phased weapons = subsystem targeting), sub nuc doff, lieutenant cmdr sci station equipped escorts/cruisers etc...
I saw a vesta doing 10k dps thread, it's built like a cruiser. Link
I saw a cruiser doing ~9k dps youtube vid, its skill tree is similar to that of an escort. Link
These above are indeed exceptional builds, but it does illustrate my point I'm trying to make people see in this thread.
Don't build a science vessel like a science vessel, and you perform better.
Don't build a cruiser starship like a cruiser, and you perform better.
Hence the title, death of sci and tank roles.
STO is the BEST game ever and the players absolutely LOVE it.