Date Time with milliseconds cell format in Numbers 12.1 on MacBook Air 2020 M1

Bugs/Undesirable Features. Workaround requested.

Desired format: 2022-08-01 16:01:30.456

1) When entering a date time with milliseconds even into a cell already formatted as such, Numbers always interprets it as text. If the cell is not formatted already as date time with ms, even changing to that format after entry does not update the entry from text to date time. Time entry also doesn't work at all for 24 hour date time either, only with am/pm typed. Even editing a currently recognized date time in a cell with ms zeroes the ms and editing the ms to be non-zero causes the date time format to be lost and to be recognized only as text.

2) Now() function does not capture milliseconds, limiting its usefulness for detailed timing.

The only way I found to get ms onto a date time cell is to add ms/86,400,000 to the cell, or type really inefficient data entries like: =DATE(2022,9,15)+DURATION(,,13,45,30,456)

I realize there are compatibility issues with processing ms on existing functions like NOW(), but isn't it a no brainer to: 1) recognize text entry that meets the cell's date/time formatting (however bizarre) and to evaluate it as such; and 2) to re-evaluate text already in a cell in accordance with a new date/time format applied to the cell?

Is there any way to capture the system time with ms?