They are not super famous but they have had some mainstream success.
I mainly found out about them when I was re-reading the Eva page on wikipedia.
The UK band Fightstar's debut album, Grand Unification, is purported to have been heavily influenced by Neon Genesis Evangelion. The track "Lost Like Tears in Rain" even contains the lyric "It's Neon Genesis". The artwork for the record portrays vast ruined cityscapes that are reminiscent of similar scenes in Evangelion. Fightstar's second album features a track called "Unfamiliar Ceilings", a reference to the Evangelion chapter "Unfamiliar Ceiling"; there is also a song named "H.I.P. (Enough)" in which H.I.P. stands for "Human Instrumentality Project". Also, the words "Human Instrumentality Project" can be seen in the album insert booklet. Fightstar's EP Deathcar also features two Evangelion-related songs. One is titled "Nerv/Seele" and the other is titled "Shinji Ikari". The back of the EP artwork also shows an image of the Lance of Longinus visibly separating the two songs from the other tracks. Their third album, Be Human, also takes its name from an episode of Evangelion (episode 22).
Here is some songs they did
Shinji Ikari - http://www.youtube.com/watch?v=GSATwg3aIco&feature=related
NERV/SEELE - http://www.youtube.com/watch?v=hVW6J8tQjrs&feature=related
It is nice to see songs directly inspired by Eva once in a while. Though Fightstar's don't exactly name drop eva stuff in their lyrics.
Anyone else knows what other songs there are that are inspired by Eva?