This is a common problem, yes.
But it's not confined to just Windows 7, or even just Windows. The resources (or resource interface) is not be released by the OS for that hardware, and thus the "drive" loaded by that hardware. This commonly happens in Windows XP, where you'll burn a disc, and then the drive shows no media or blank media -- even though it's burned, and the disc and CD/DVD drive are both fine.
A common fix is to simply reboot. No, not for each disc (that would be insane), but just once. The computer may be confused, and stuck in a loop of confusion.
You may have other software on the system that's trying to "own" the drive when a disc is inserted. Various protection programs are notorious for this, such as malware detectors or anti-virus software. Be very sure that the system has all auto-plays disabled -- either manually corrected*, or by way of the $30
Tweak 7 software (Win7 version of XP's famous TweakUI).
* Manual method: Go to Control Panel\Hardware and Sound\AutoPlay. Uncheck Use Autoplay for all devices and Click Save.
I doubt it's the discs, drives, motherboard, etc -- I think your Windows 7 operating system is getting confused by conflicting requests. One of the downsides to optical media is the "safety" mechanism that allows software to lock the drive, preventing other programs from having any access to it while it's in use. I fully believe you're running into a bad scenario caused by this mechanism of the technology.
Extra: Since I'm volunteering tips for Windows 7, I highly suggest the freeware Classic Shell, which restores most Windows functionality removed removed from Win7, but previously available in Windows 95-XP and Vista. For example, the up arrow in Explorer, which lets you quickly jump back up one folder without having to navigate the limited hierarchy dropdowns. Without Class Shell installed, I consider Windows 7 unusable as a working person's OS.