This is going to depend on what your purpose is. What device do you want to use? What display do you to use? What kind of video connection do you want? Where are you getting the games from? Yes, this is going to be long.
If you want original game cartridges (I'm not including SD carts in this for now) and you want that authentic experience, get a regular Super Nintendo. If you don't care about connections, the standard composite connector worked fine for years, but it will look muddy on a modern display.
If you want something quick and easy and just have a sampling of games, the SNES Classic is the way to go. It'll work with modern displays, and the games on it are fantastic. Some people like to reflash the board to get more games on the thing. Not my thing, personally, but to each their own.
If you want the catridges but want maximum compatibility and the ability to play these games on a modern display, get a Super NT. 200 bucks and you can throw ANYTHING SNES related into it and it'll work. You'll have to provide your own controllers, though.
The use of ROM carts like the SD2SNES is interesting enough. I'd say if you wanted to use something like that, I'd use the Super NT as well. Some games don't work on the Super NT, and if you have those carts, those will.
If you just want to play the games and don't care where you play them, then emulation on other devices is the way to go.