The canonical example of a function continuous at only one point is
$$f(x) = \chi_{\mathbb{Q}}(x) \cdot x$$ which is continuous only at $0$.
A user on another question pertaining to this issue has also stated that if $g(x)$ is a bounded and nowhere continuous function, then $f(x) = x \cdot g(x)$ works.
Do we have more exotic, nontrivial examples dissimilar to ones of this form? What are some necessary conditions?