Things were generally more optimistic in the US than post 9/11 - you had the end of the USSR and unification of Germany, and a booming economy. Even the recession that hit in the early 90s wasn’t that bad. There was a feeling like we were past the era of worrying about nuclear war or being drafted into some Vietnam-style quagmire, and that the internet was opening a new era of openness and prosperity. Not all of this was entirely true at the time, and certainly isn’t true in hindsight, but I would say that was definitely the vibe. The US seemed healthier politically, but this was also the era where the start of the modern ultra-right conservative movement started and the Contract On America stuff started.
70’s were far enough back that they were retro enough to revive, but I don’t remember there being any more 70s revival in the 90s than there was 60s revival in the 80s, it was just a thing some people did. I do distinctly remember going to a club and encountering the BeeGees as dance music. People in their 20s liked a lot of different stuff - there were people in their 20s who liked them, others who liked R&B, country, or pop instead, and others who sneered at them for being whiny nu-metal posers while listening to harder stuff. Most trends like that are regional, local, or even limited to specific social groups than people looking back like to think.
Fads like the Macarena are just general dance fads that come and go, I remember it as being one of those flash in the pan things that I didn’t really have anything to do with, and the idea of ‘fondness or horror’ seems a bit overwrought to me. Not sure why there’s a specific question about the Cranberries, they had a few hits but weren’t any kind of big pop culture phenomenon that everyone knew like MC Hammer or Pearl Jam.
I am not sure what the “Multimedia Revolution” refers to, I don’t remember that phrase (unlike “Information Superhighway” which was hilariously overused). That was the time when people started having multimedia games at home and CD burners were around (expensive and cantankerous, but you probably had a buddy who had one). One thing that you didn’t ask about but a major change was that the WWW was just kicking off at this time, this was the time when you’d start to expect any big company to have a website and anyone doing ‘customers contact me’ type sales work to have an email address. It wasn’t like now where it’s unusual for any company with more than a dozen employees not to have a web or social media page, but things went from ‘what even is the internet’ to ‘you should have an online presence’ really fast.