The Super Nintendo IMO, was when Nintendo was at a creative and commercial peak with their software.
Creative is subjective,
Commercial is measurable, and it's demonstrably false that SNES was Nintendo's most commercially successful console.
https://www.resetera.com/threads/nintendo-software-and-hardware-sales-data-from-1983-to-present.2725/ - Data taken from October 2017. Except Switch, which
1. It ranks 7th in overall hardware sales, and will soon be 8th as the Switch rockets past.
2. Wii and DS both approximately tripled the SNES in total software sales.
3. SNES had 87M total first party sales, which currently puts it only ahead of Gamecube and Wii U, 10th overall, already behind the Switch
4. Software tie-in ratios is 7.72, which puts it behind the Wii, Gamecube, NES, and N64, and barely ahead of Wii U's 7.56M (and it still may fall behind when it's all said and done).
5. At 18 games, SNES is tied for last place in the total number of games they published for the console, and several of those (such as the DKC trilogy) were developed by other companies. This is less than half the 41 games on NES, and precisely half the 36 on N64.
6. The top selling (mostly) unbundled game on SNES was Donkey Kong Country at 9.3M, compared to the top selling (mostly) unbundled game on other consoles: Switch is Mario Kart 8 Deluxe at 13M+ and growing, Super Mario Bros 3 on NES at 17.28M, New Super Mario Bros on DS at 30.8M, and Mario Kart Wii at 37.14 million sales.
It's clear that SNES was nowhere near Nintendo's peak commercial performance. Of Nintendo's top 5 financial years, 4 of them are during the Wii/DS era, the 5th is fiscal 2018, though 2019 and 2020 are sure to beat it. The early years when the SNES did very well financially also coincide with high NES sales (since in Europe we didn't really get a wide release of the NES until around the release of the SNES, and this is probably true for most of the rest of the world), and the first GB bump occurred then. Commercially, the SNES is about level with the N64, Gamecube, and Wii U eras (mostly held afloat by handhelds), but falls WAY behind Wii/DS and Switch eras. By the charts, it's clear Nintendo's commercial peak was 2007 to 2011, and the only generation that even comes close is the current one.
As for creative peak, I'd argue the creative peaks for Nintendo were NES, the N64 with the move to 3D, and the Wii era with the introduction of motion controls. The SNES had some creatively adventurous titles (Pilot Wings and F-Zero), but most were refinement titles, and in many ways broke less creative ground than the refinement titles of other generations (e.g. SMB3 was a much larger jump over SMB1/2LW than SMW was over SMB3). Earthbound was creative in how it was a parody of Dragon Quest and other RPG tropes of the era in a modern era, but it didn't break the same level of ground that Xenoblade Chronicles on the Wii broke in the RPG genre, or arguably Xenoblade Chronicles X, either, and that one was on Wii U - which is the console you don't even think is worth talking about). Donkey Kong Country was the most innovative game on the console, at least from a cosmetic perspective in how it meshed in pre-rendered textures, but that one was done by Rare.
I like the SNES a lot, but it's not for it's first party output. It's mainly for the Square and Enix output.