I find Voodoo 2 ideal if you can only allow yourself a single retro-PC (space restrictions, for instance).
If that´s the case, and one wants to cover a relatively wide era of vintage PC gaming (let´s say 1993-2001/DOS-Win98), then picking a Pentium III based machine is quite a natural choice. The AGP slot would be destined for a GF2-GF4 class card (or Ati 8500) to deal with late DirectX/OpenGL Win98 titles. The voodoo 2, installed in an available PCI slot, would be best suited for covering the earlier years of Win9X Glide 3D games.
To the question, paying $200 for a Voodoo 2, is it worth it? There is no easy answer. A Voodoo3 is better and a bit less expensive (for now). You can get a GF2 GTS on eBay for around $30, outperforming both.
Some here have mentioned nGlide as an alternative, some spoke about nGlide not being accurate enough.
It´s a similar situation to what happens in the console collecting world; is it worth paying those current prices when you can emulate (RaspberryPi) or use flashcarts/ISO loading devices?
Yet again, some systems are not accurrately emulated yet (Atari Jaguar or Sega Saturn, to name a few) or are not easily moddable.
Besides...nostalgia. When it comes to "re-creating moments", It is not the same "feeling" owning the real, piece of history, hardware than alternatives. It is not the same thing holding a Voodoo 2 in your hands than a GF FX Series one (that yes, outperfomrs it and can emulate it through nGlide).