I don't why people get so excited about quaternions, like they are some mystical concept.

Personally, I think one is better off learning some Differential Geometry and Abstract Algebra to really appreciate the broader context in which these exist.