This game has always surprised me. It was developed by Vivid Image (S.C.A.R.S.) for seven platforms and all the console versions had a very different graphical approach, depending on the platform's strength.
Super Nintendo version (1994) was, of course, a Mode 7 game, pretty much a copy of Super Mario Kart. Tracks design was alright, with colorful but a bit empty levels. It also featured cars soccer ala Rocket League (not the precursor, of course, Wild Wheels was already Rocket League in 1991).
Genesis/Amiga version (1995/1997) had a very basic raster road technique (just a road image linescrolling left and right). To be honest it is really awful. This version also features the soccer mini-game and it makes even less sense than on Super Nintendo, it probably has the worst scrolling I have ever seen on an "sports" game.
Saturn version (1996) uses a rotatable layer similar to the mode 7, but with much higher resolution, farther zoom and 3D elements with a subtle dithered spawning. Some objects are just 2D billboards that always face the camera. I'd say it is the best looking version, by far. It does not feature the soccer mini-game, but a circular battle arena instead, with a tilted view.
Playstation version (1996) is the way to go for the "polygon crew". It features fully polygonal circuits with different heights. Of course objects, vehicles and trees are still 2D billboards. It looks cool and clean, but not as great as Saturn. Also, render view in multi-player is probably the shortest I've ever seen on Playstation, beating even Driver 2. It features the same arena as on Saturn, but this time is fully 3D and it has a few extra-cameras.
Street Racer is also notable for the multiplayer aspect. Both Super Nintendo and Genesis support 4-players split-screen. For some reason, the viewports are stacked onto each other, instead of the classic 4 way split-screen display. It looks highly unplayable. Saturn and Playstation version were probably the only EIGHT-players split-screen games of all time.. at least until very recently with games like Screencheat (2014) and Virtua Racing Switch (2019). I wonder if someone ever played this mess with seven friends back in 1996.
The DOS version was basically the Playstation version with SVGA graphics. GOG's sale includes both DOS and SNES versions.