[RPG] What sourcebook has 0th-level psionic powers

I am simply looking for something rules based before I attempt to do something homebrew.

Sadly, you're not going to find something "rules-based", because it simply doesn't work within the balance of the game. Psions are already quite competitive with Wizards and Sorcerers. Giving them an outright "spellbook" option would make them the single most powerful class in the game.

Just quickly compare Psions to Wizards and Sorcerers (their two closest counterparts).

Wizards

• get a limited number of spells / day (max 4 / spell level)
• can learn lots of potential spells (given the funds to do so)
• get new spell levels at character level 3,5,7...

Sorcerers

• get a high number of spells / day (max 6 / spell level)
• can know only a limited number of total spells
• get new spell levels at character level 4,6,8...

Psions

• get a point pool, but if you add it up, it's roughly between Wizards and Sorcerers. It's actually higher at low levels.
• can know only a limited number of total spells, but that number is greater than the Sorcerer.
• get new spells levels at character level 3,5,7...

Some subtle trade-offs

• Sorcerers tend to know a lot of "less useful" spells. A 7th level sorcerer has 10 spells known (5/3/2), while the Psion has 15. The sorcerer can cast Fireball 4 times (7d6), but the Psion can cast it 6 times (7d6). Psions can use their most powerful spells more.
• Most Psion combat spells scale DC and damage. They cost more points to cast, but your "Fireball" (aka Energy Ball) has a tougher save as you level up the damage. Fireball tends to become weak in later levels because the DC becomes so low that most creatures can save. Sorcerers end up having to pick up Delayed Blast Fireball just to get a higher DC.
• Several Psion abilities actually scale "within themselves" giving you a virtual two-for-one or three-for-one deal. Take a look at Dispel Psionics. It is effectively Dispel Magic + Dispel Magic, Greater for the price of one spell slot.
• Because Psion spells "scale", the use of "Metamagic" Feats is much more limited. This means that you can often spend your feats elsewhere (like on even more spells).

Hopefully it's clear by now that these elements are designed with some balance in mind.

If you want to homebrew...

The easiest model is simply to tweak the Psion class to re-balance the trade-offs.

• Drop the number of Power Points to bring it inline with Wizard "spells / day".
• Change the first level "bonus feat" to "scribe scroll" (aka Power Stones).
• Drop the "Discipline Abilities" as these are effectively Sorcerer Bloodlines.
• "Arcane Bond" stays pretty much the same.
• Use the Wizard "spells / day" table for the number of distinct spells that can be memorized.

Note that in some ways, this Wizard Psion may be more powerful than a regular Wizard (already the second strongest class in the game). You may need to tweak this to "power down" the Wizard Psion.

To answer the question at the end: Yes, the "trick" of using Sneak Attack with a power like Energy Ray works, and can yield a relatively high number of damage dice per manifestation under good circumstances.

To answer the question implied by your title: Hardly. The Psychic Rogue is harshly limited by his power list, power point total and feat availability. Consider the damage potential of any full manifester using multiple actions/round and (preferably multiple) metapsionic feats.

The short version: It works, but it's less awesome than you think it is. Full manifesters do blasting better, let Psychic Rogues stick to... rogue'ing.