Although how good a spell is can be subjective, not only shifting based on personal opinion but also on what obstacles you're likely to face, Enhance Ability is versatile enough that it'll probably prove practical in most campaigns. What's more, it provides advantage, which isn't something that becomes less useful at higher levels, making it useful for longer than other spells of its level. Often underrated and forgotten, Enhance Ability is an excellent spell!