Super Mario Kart is easily the worst Mario Kart but it is far from a bad game. My biggest recommendation for this game is to give it some time to learn the controls, once you do this game can be fun. I should also mention that the CPUs blatantly cheat but there isn't much they can do if you just keep your acceleration going.
My favourite tracks are Rainbow Road and Mario Circuit 2 while my least favourite track is Bowser Castle 3. Music isn't super crazy but I do enjoy Koopa Beach and especially Rainbow Road.
Give this game a fair shot, it paved the way for future kart racers.