State of the art imo is Metroid Prime
Loading screens are hidden, it's not like the contemporaneous PS2 game Mafia where you wait a few minutes to load, spend a few minutes driving across town on a mission to shoot up some people at a restaurant, get yourself shot up, then have to wait for it to load all over again.
But let's be real, it's Super Metroid. :)