Is building an ADU going to make you a cool cat?

No, if you're not a cool cat now building an ADU is not going to change that. Building an ADU can be a very cool thing to do though and you might help provide housing for someone.