It's been a long time. Probably Resident Evil 4.

Super Metroid is incredible indeed.

Last played for me would be Skyrim.

Okay I want you to explain it to me from your perspective what made it great or deserving of a 10 explain to me some of the flaws as I've heard there's a lot missing

The last of US, Portal 2, Mario Galaxy

For me, it would have to be Skyrim.

My perfect 10s/experiences:

Final Fantasy 6
Chrono Trigger
Bioshock
Bioshock Infinite
Mass Effect Trilogy on a whole
Super Mario 64

I dont think that there are any perfect 10's out there but this one got pretty damn close for me. Come to think about it, there are not that many games that I hold so high on this list as TloU.

There's a lot of games that I'd give a perfect 10, but I haven't played a lot of them, like BioShock Infinite or Super Mario Galaxy 1 & 2 for that matter, probably even the first BioShock (i played about half). I would add Def Jam fight for New York, just because of its diversity and skills and abilities, but it missed on so many levels, but it is one of those games that I'd play over and over and over again, and I think that's how you define a perfect 10.

I think a perfect 10 would have a lot of replay value so even Area 51 the first one not the second one would be a perfect 10 for me. Someone already mentioned Valkyrie Chronicles and Uncharted 2. I would definitely give mor nation racers a perfect 10, it was addictive, I still have it, and if I still had my PlayStation 3 I'd still be creating tracks on it.

I'm surprised no one said Final Fantasy 7, and LittleBigPlanet 1 had one hell of a degree of difficulty in my opinion and Little Big Planet 2 I'd give them both a perfect score of 10 out of 10

Probably banjo kazooie. I've played quite a few games since then that has fun factors of ten, maybe even more fun than banjo kazooie, but had some flaws or glitches that prevent me from giving them a higher placing.
Banjo kazooie just doesn't have any obvious flaws I can think of. It was fun and worked perfectly