I don't know of a great resource that compares one platform to another like that excellent parent post up there.

However, if you want to know more about individual platforms, you may want to look for:

1. Homebrew coding tutorials for various retro platforms

2. "War stories" from devs who pulled off these tricks.

Gamehut is fantastic, with some of each: https://www.youtube.com/channel/UCfVFSjHQ57zyxajhhRc7i0g/vid...

Ars Technica also has a "war stories" video series that is quite good!