Quote Selection Do What I Mean (DWIM)

[Nordlöw]

If transient-mark-mode is activate it would be nice to have some
clever major-mode-sensitive auto-insertion of single quotes and
backquotes.

in emacs-lisp-mode we want the following mappings
- ' => `symbol' in comment-syntax
- ' => 'symbol in code-syntax (no change
- " => "string" everywhere

Does emacs have a suitable before/after/replace hook related to self-
insert-command that can be used to realize this behaviour?

Suitable function name could be quote-dwim().

Has anybody already done this? Reflections...

Thanks in advance,
Nordlöw