Have you tried Mass Effect?

It's pretty much exactly what you're asking for. Combat plays out like a 3rd person shooter, but it's still primarily an rpg.