If you only want to use such old software, a Tandy 1000 or a Turbo XT of some kind would be a good choice. If you want to be running more Windows applications, look at ATs and Turbo ATs (286 machines). 386s are also fair options, but can run some very old software too fast.
Tandy graphics only work on Tandy machines, just as their sound used to, before it was emulated.
If you get a 286 or 386 you could use a VGA card and literally any VGA monitor made between 1988 and current date. 8-bit VGA cards do exist but they are expensive and rare, iirc. They will all be backwards compatible with CGA/EGA, but obviously no Tandy or Hercules support.
MDA and Hercules use a monochrome TTL monitor which does not have a "Modern" equivalent, since they are entirely digital and work on a frequency which is no longer common. MDA and CGA monitors are not even interchangeable.
CGA and Tandy both use their own connector as well, which is a similar TTL setup that does not have a modern replacement. They are also digital and work on a frequency which is considered odd.
EGA is again, it's own digital connector. However, EGA monitors are backwards compatible with the CGA connector and will display their picture as well. Some EGA cards have VGA outputs (Zenith Z449) but are still just EGA chipsets with the extra connector and DAC for a VGA monitor. Some include special modes (ATi cards) which were rarely used by games.
Obviously there are more standards like PGC and Plantronics which are not worth mentioning for your purposes.
For most people, a VGA card will do all of the above. It can emulate MDA, CGA, and EGA with reasonable accuracy while also providing the improved performance and a more standard output. It also gives you the option of running actual VGA software.
Tseng Labs ET4000 and Trident TVGA8900 series are very common choices for vintage machines, cheap and plentiful they do most of what you'd want from them without complaint.
tl;dr some generic 386SX with a basic VGA card and a CF adapter.