Most RAM found in consumer PC's during the 90s was still DRAM, including SDRAM, EDO, and Rambus. I believe OP is just being nostalgic over the period of time when RAM upgrades were very a exciting thing, as hardware was changing very quickly in that era and each year felt considerably more capable than the prior.
I'm not sure it's easy to understand what a big change there has been in the perceived pace of computer technology development if you weren't there. I'm typing this on a laptop that I purchased 11 years ago, in 2013. It's still my one and only home computer, and it hasn't given me any trouble.
In 1994, though, an 11 year old computer would already be considered vintage. In 1983 the hot new computer was the Commodore 64. In 1994 everyone was upgrading their computers with CD-ROM drives so they could play Myst.
Hilariously enough, you could still purchase a brand new Commodore 64 in 1994... albeit right before Commodore went bankrupt in May of that year. I vaguely remember some local electronics store in Pittsburgh having Commodore 64s for sale on the store shelves for really low prices back in the day. Admittedly, this was an unusual sight to behold in the US, because we had well since moved on to IBM PC Compatibles by then. In Europe, C64s were a tad bit easier to source.
It was definitely more of a curiosity and a toy rather than a serious computer in 1994.
In fact, I'd venture as far as to say that all memory in personal and/or "home" computers, starting with the earliest generation (Apple I & Co), has always been some variation of DRAM - with the possible exception of the external cache memory chips used by some CPUs (e.g. 486, Pentium IIRC).
There were SRAM-based home computers, they just weren't very competitive when DRAM-based ones could offer 4x the RAM for the same price. VIC-20 did well for its day, though.
My first "home" computer (a home-built COSMAC Elf) had 256 bytes of static RAM (in two DIPs). No DRAM at all. I don't think Radio Shack even sold DRAM.
