Yeah, you got a $900 box that can't open a spreadsheet, run GIMP or Blender or multitask, and it can't be modded much, but on the upside it'll play COD at almost the speed of a decent gaming PC.
And the gaming industry created this problem, by not allowing you to do something useful with your console once it's no longer useful as a console, by locking it down and never providing an unlock. Thousands of us hacked our Xboxes and used them as media centers, then Microsoft made this infeasible going forwards. Sony did the same with the PS3 and "Other OS." Nintendo has just always been locked down AF, but we used to have some freedom with some of the game boys... so much for that.
I have zero reason to buy a console because it has zero value after it's been a console for me.