It is only lately that I started to play with Lightroom which appears to have "Adobe Color" profile for all supported cameras, seemingly negating their unique color characteristics, no?
The "Adobe Color" is actually new. Before that, the profile was "Adobe Standard", and yes, LR does largely negate the color differences between cameras, but that is because Adobe basically has a color profile for each camera. If you convert the raw files to DNG, ACR/LR actually embeds all the color operations it does as metadata in the file that you can inspect with exiftool. Once you get a few cameras through your system, you'll find that there's a pretty significant amount of hoop jumping that happens to get them all to look so similar. This is why when a new camera gets released, unless Adobe had access to it ahead of time, it takes a while for ACR/LR to support the raw files. Adobe basically has to go figure out which profile they already have is a best match for that sensor and/or tweak/build a profile for it and put it into the code. This is on top of looking to see if they can even parse the file with existing code or if they need to write a parser for it. This is not a trivial amount of effort.