There are still plenty of rpg elements intact and the main game has nothing to do with multiplayer. Just don't pay any attention to the multiplayer.
I don't know why everyone expected or expects, any future game in the Mass Effect series to compare to the trilogy. There is no way, no matter how hard they try, to even come close, to what Shepard's journey brought us; story-wise.
Andromeda is not a bad game by any means. It's story is not going to blow anyone away. But if you are a fan of Star Trek, Battle Star Galactica, you will find a lot to like here. It's a game about settling and exploring a new Galaxy. That in and of itself is what intrigues me. Like Skies of Arcadia, for example, being able to explore the unknown; seeing something fresh for the first time is what draws me into this game. If you love exploration and adventure; something with a decent story, but not some grand epic opus, you will find a lot to like with Andromeda. The story is fine for what the game is centered around.
Though, I can totally see why people can't bring themselves to play it after the main trilogy! I thought that way going in, but was pleasantly surprised. This is still a high quality title, with a different take on the Mass Effect universe. If you can accept it for what it is and just stop comparing it to the main trilogy, you will find a lot of fun to be had here: full of detail in environments, design and depth (just looking up at the massive monoliths and Remnant technology has me in awe sometimes!)
This is likely to be the last Mass Effect game with the original teams creativity and magic touch left intact, as most of the team is gone now. I shutter to think how un-Mass Effect-like the next game will be, with having lost so many original team members. Which is why I recommend fans still give this game a chance. Just think of it as it's own game with Mass Effect connections.