MySQL is sufficient for desktop users and dynamic web sites. Few home users would actually need a full database management system, but it is a useful thing to have around. Every home user wants games. There are umpteen tiny games, many text-based, right up to commercial packages like Quake III Arena, and for good measure, everything in between. But there are so many other interesting things, that games are often neglected.
Multimedia is a weak point with Linux.
Sure, sound works after a few tries. The capability is there, but it needs to be coaxed along. Start by installing Apache. Most distributions already install this as part of the default installation. If you see the Apache test page, then you know it's up and running.