First, my apologies for saying Carman and not Carnac.
I don't care what you call it, as long as we communicate. I only capitalise CARNAC because I think of it as an acronym rather than a name. I also understand that you use Emby and Plex, and need to take their requirements into account.
I believe that MC will do
everything that you want it to do. Without compromise.
I believe that MC will work with Emby
exactly the way you want it to. Without compromise.
I also have no problem with you using TheRenamer to rename your files before letting MC import them. With at least the example on their web page, it does a better job than CARNAC in reading a file name to extract metadata.
MC, as an application, gives you enormous control over what it does. Sure, CARNAC is an automatic process to make a "best guess" at what a file it when it is imported, and you don't control the inner workings of that. Consider that a "first cut" at getting tags correct. But then you can use "Fill Properties from Filename" in automatic mode or with templates to update tags in MC, and/or use the "Rename, Move & Copy Files..." function to rename files to anything you want based on tags and text you tell MC to use.
What is even better is that if you use TheRenamer to name files with ALL the good information it collects, in the format "The Unit - S01E01 - First Responders.avi" for example, CARNAC will get its guess right the first time, every time.
But you seem to have a misunderstanding about what MC is and how it works. Which is a surprise since you have been using it since 2003 at least. I hope that RD James' post helps you understand MC a bit better.
I also believe that your idea of file naming sucks really, really badly. The format you are using, which is [Season][Episode].[Name] where [Name] is the episode name, and an example of it is "0101.First Responders.avi" lacks the information you need to know what the file is. You
must have the Series name in addition to that to know what you are about to play. Which leads me to believe that you are using both Plex and Emby by drilling down through directories and subdirectories to find the files you want to play. That just isn't necessary with MC. But you can do it that way using MC so that Plex and Emby are supported. So I assume you have subdirectories similar to;
\TV Shows\The Unit\0101.First Responders.avi
Which then makes sense as you drill down through the hierarchy you have created, you can easily see and select which Series you are going to watch.
But MC doesn't care about the file name, which subdirectory it is in, or even where it is stored. It only cares that it can find the file to play, and about the data in its library. So there is no need to force MC to display the file name without extension in the [Name] tag, as you can just get MC to display the tags;
[Series] [Season] [Episode] [Name]
in columns in a View and it will display for you;
The Unit 01 01 First Responders
Which is what is necessary to know what program the library record is pointing to, so you can decide to play it or not.
So, if you open your mind to the idea of not putting the filename without extension into the [Name] tag, I think we can work out how to do what you want. Otherwise, good luck. But don't give up on MC just because you don't understand it.