Warframe is a game that rewards you for the amount of time that you invest into it. If you wish for a surface level horde shooter with fun abilities then it will give you that experience in spades, however, it also has the ability to allow you to delve deeper into its systems and lets you customize and maximize your arsenal until you become a walking army.
The story is serviceable in the beginning but in my opinion ages like wine as you progress through the star chart, slowly pulling you into an experience that I have yet to relive in any other Sci-Fi game I've played. While it does go off the rails at times it does so in a way that feels believable and maintains a sense of internal consistency that keeps you informed while still asking questions.
Each frame feels unique even though the devs have released over 50 differing characters, each with a unique kit that (while falling into a manageable amount of categories such as caster vs weapons-platform) still allows players to express their own uniqueness through their selection of frames and weapons. It is rare that any two players' loadouts will be identical to one another.
It is definitely a game I recommend everyone to play at least once and one I definitely recommend to anyone who loves long grinds, deep (though sometimes confusing) mechanical systems, and extreme horde shooters.