Perfect Dark Zero in 2005 was probably the last title in either of those veins, which was a launch title for the 360 (soon to be 2 consoles ago!)
Sea of Thieves is certainly a feather in their cap, it's just a bit disappointing that we haven't been able to see Rare take a modern crack at the things they were so known for, if that's even possible now.