As someone who had used Prodigy since 1990 and began my CS program in fall of '94, I was extremely excited to get a much faster than 14.4k connection in my dorm room so I could use Mosaic at a proper speed. I seem to recall this was a universal feeling amongst other students in my class... like a "holy sh*t, I can't believe I have this level of access now".
But I only really started to enjoy the Web with 33.6k and by 56k I was completely hooked. That’s my recollection at least.
I loved IRC and BBS, but the Web took a while. Mostly because it was so slow.