No!
Not exactly. You don’t have to reflect footprint in name provided you use more libraries.
You describe conception I was using with Protel (we bought Protel 3 in 1997 and were using it till I moved in 2017 to KiCad).
The main assumption was to be able using only the symbol name to select all rest element information (to make BOM) from spreadsheet (first tab contains database, second tab makes BOM by using functions allowing to select fields from first tab).
The other was that use of new R value needed to design new symbol so it was the moment to consider once more if we really want to extend number of drawers to store resistors or may be we could use some of values we already store.
In Protel symbol names meaning was:
1k = 1k 0603
1k_4 = 1k 0402
We used UniversCondensed font to have the names at schematic not too long.
When decided to move to KiCad (4.0.7 was first I tried) I found that I can’t use UniverseCondensed font and names are too long. As practically to understand schematic I don’t need the information about footprint so I decided that both 1k 0603 and 1k 0402 can at schematic have the same symbol name: 1k.
I have checked if I will be able to make my spreadsheet database serach not only by symbol, but by symbol concatenated with footprint and found it is possible.
The problem is that KiCad don’t allow to have two symbols with the same name in the same library.
Because of this I have library R and there 1k means 1k 0603 and library R1 (from 1mm length) and there 1k means 1k 0402 and library R2 (from 2mm length) and there 1k means 1k 0805. The same with capacitors.
For ICs I don’t use the same symbol for different packages. At first selection of some IC I use its short symbol name assuming that the case we use are just default for us. For many ICs it is the end - we never use it in another case. But recent problems with ordering elements forced us to use what was available at the moment. The effect is that I have in library:
HVD72 - combinded case SO8 + VSON8
HVD72D - SO8
HVD72DGK - VSSOP8
HVD72DRB - VSON8
It is the only IC I have in library 4 times. Most others I have only one time in library.
I am repeating information that I have already written. Here are the previous posts with full explanation (and examples) of my BOM generation I have designed in ‘Protel times’ and modified when were moving to KiCad.