Lots of different display/storage methods in the original post.
There are a lot of options here... this is how I would summarize what I have learned from my current spouse and threads like this.
Things to consider...
1. How much of your collection do you want available at a time?
2. How much space do you have for display at any one time?
3. Are you going to buy storage, like bins, totes, shelves etc, or can you going to build your own?
4. If displaying many consoles, do will they be hooked up, or just readily available for hook up?
I will show some of what he did with our (mostly his) collection and why... the reason for why is based on the above questions for consideration... because of space, which we ran out of. Note that this will not apply to some people as all of this is custom built.
First, he wanted all the boxed PC FPS's displayed front out and easy access because of the box art... so above one meter or so around the entire room is shallow shelves which hold the boxes face out. This takes a LOT of space to display this way, was custom built, but serves Display and Access criteria very well.
Then, for console cartridges, one project was these two Rubiks Cube chairs. Everything has to be multi-purpose because of space constraints. This is non-display storage, but still quick access as the sections just unstack.
For the "modern consoles" the criteria of Quick Access and storage density was more important than display of the box art/packaging so this was the outcome. (several years old image, so looks different now) The consoles are stored on the row under the TV and under that are the most accessed cased games. The number of games did grow too large for all four consoles under the TV (PS2, PS3, Wii, XBox) so only PS2/3 Games fit there now)
Well here is one more method of custom construction storage that is the result of running out of all that wall space pictured above. The ceiling was still available (at the time) so custom brackets were made to fit glass shelving... this was the result.
I have more examples to post to do with plug-n-play and handhelds, but have to go for a bit and this is getting really long. Hope this helps.