Any game that is specifically designed around a given hardware platform will usually end up fine assuming the concept and design is strong to begin with. This is why Nintendo developed titles rarely have any problems with respect to the hardware they've been developed for; they're designed around the strengths and limitations of the hardware.
That said, plenty of games can always take advantage of additional resources, whether that be more memory, more computing cycles, more storage, etc. ; some more than others.
How developers use those resources matters just as much as what those resources happen to be.







