I believe that SNES had optional mouse, but I never seen or used one. Also I am not sure if the games did support it.
I tried Civilization on SNES with gamepad, and it takes some time to get used to it.
But consoles were great for platform games where multiple buttons made different experience with the game. Games such as Flashback, The Lost Vikings etc. were much more playable with consoles. It was nice to have Sega MD/Genesis controller with miggy, but still only two buttons worked for some games.